If a series of cells on sheet 1 are blank, I want nothing to happen. If there is any text in any of those same cells, I want certain other cells to be transferred to another sheet. I THINK I should be able to do this with the "onEdit" feature but I don't know how to write the script specifically for my sheets and I don't know how to assign the onEdit script TO the sheet once it is done. (I may not even know what questions to ask, either. This is my first attempt at this type of function)

Yeah, I know. It is a pinball forum. It is also the only forum I belong to and I thought it was worth a try.

Thanks.

You're currently viewing posts by Pinsider jbrady65tv.
Click here to go back to viewing the entire thread.

Reply

Wanna join the discussion? Please sign in to reply to this topic.

Hey there! Welcome to Pinside!

Donate to Pinside

Great to see you're enjoying Pinside! Did you know Pinside is able to run without any 3rd-party banners or ads, thanks to the support from our visitors? Please consider a donation to Pinside and get anext to your username to show for it! Or better yet, subscribe to Pinside+!

This page was printed from https://pinside.com/pinball/forum/topic/anyone-here-a-google-sheets-onedit-expert-or-even-somewhat-trained?tu=jbrady65tv and we tried optimising it for printing. Some page elements may have been deliberately hidden.

Scan the QR code on the left to jump to the URL this document was printed from.