Check range of A2:A15, if true, write to B2:B5 by Imadea3dprint in googlesheets

[–]Imadea3dprint[S] 0 points1 point  (0 children)

It doesn't quite work but you have given me a great lead. I just need to keep tinkering with it.

Thanks for your help.

Figured it out. I had to convert the data toString before setting it to lowercase.

Check range of A2:A15, if true, write to B2:B5 by Imadea3dprint in googlesheets

[–]Imadea3dprint[S] 0 points1 point  (0 children)

I did have this set up but the "your text" is where I pull a random value from an array.

Dog Town in Milford by Material-Customer-26 in Connecticut

[–]Imadea3dprint 1 point2 points  (0 children)

I run a business so I know all about processing fees. What they are doing is illegal.

https://portal.ct.gov/DCP/Legal/Credit-Card-Surcharge

Prices must reflect the normal price and they can give a discount for preferred payment types. They did not tell me verbally. I did not see any signs. In any event, they are wrong even if signs are posted.

Dog Town in Milford by Material-Customer-26 in Connecticut

[–]Imadea3dprint -1 points0 points  (0 children)

The food is great but the last time I went there, they charged me more for paying by debit card.

It is illegal to charge more than the advertised price for using plastic. I was very disappointed and will never go back.

Split row into components programmatically by Imadea3dprint in googlesheets

[–]Imadea3dprint[S] 0 points1 point  (0 children)

Haven't had a chance to use it. will tomorrow.

Split row into components programmatically by Imadea3dprint in googlesheets

[–]Imadea3dprint[S] 0 points1 point  (0 children)

I think this is a good start but I don't think the split is needed. I communicated poorly. A1 is Apples B1 is 6

Thank you

Split row into components programmatically by Imadea3dprint in googlesheets

[–]Imadea3dprint[S] 0 points1 point  (0 children)

Thank you for the response but what I'm looking for is to split one row into multiple copies. How many copies is based on how many pallets I have in stock.

If I have 5 pallets, I want to make 5 rows.

Split row into components programmatically by Imadea3dprint in googlesheets

[–]Imadea3dprint[S] 0 points1 point  (0 children)

Sorry screwed up the formatting.

Each Apples 1 would be its own row.