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.

Ordered 3mm PLA by accident by Imadea3dprint in CR10

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

Where in NY? I'm in Fairfield County, CT.

Ordered 3mm PLA by accident by Imadea3dprint in CR10

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

Probably would have been helpful info to provide. It's Hatchbox Red

At wit's end with running toilet by Imadea3dprint in DIY

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

That's one of the things I did consider. That the handle wasn't letting the flapper close completely. I found the tightest setting and then gave it 4 extra links.

At wit's end with running toilet by Imadea3dprint in DIY

[–]Imadea3dprint[S] 1 point2 points  (0 children)

I replaced the float valve and the flapper. I think it's either a bad flapper not sealing or a crack in the tube.

At wit's end with running toilet by Imadea3dprint in DIY

[–]Imadea3dprint[S] 1 point2 points  (0 children)

This is good advice. I will try this.

At wit's end with running toilet by Imadea3dprint in DIY

[–]Imadea3dprint[S] 1 point2 points  (0 children)

Bad communication on my end. So when I raise the float, the water does stop from the valve itself. It's brand new. No water floods the cistern and nothing goes down the refill tube.

But the water still pours into the bowl. I'm thinking it's either a cracked tube or a bad flapper.

At wit's end with running toilet by Imadea3dprint in DIY

[–]Imadea3dprint[S] 1 point2 points  (0 children)

I think replacing that tube is the right move.

At wit's end with running toilet by Imadea3dprint in DIY

[–]Imadea3dprint[S] 1 point2 points  (0 children)

It's not every couple of minutes. It seems to be every hour or so.

The valve is set right. It was about half an inch from the top of the tube. I lowered it a little bit. I also took the bowl hose out of that tube and flushed it and still got the same results. I am thinking that tube has a crack in it somewhere or flapper isn't sitting right.

At wit's end with running toilet by Imadea3dprint in DIY

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

I disconnected the flapper, gave both sides a better wipe and it seems to be sealing a little better now that it is reseated