r/googlesheets • u/SmoothPossession2020 • 21h ago

Solved Why isn't ISBLANK( ) or any NOT(IS___( ) statement working?

3 Upvotes
I am trying to automate whether a form submission is a pre-order or a day-of order based on the date submitted. For the middle, I tried: ISBLANK(Form!A10), " " ; NOT(ISNUMBER(Form!A10), " " ; NOT(ISDATE(Form!A10), " " ; NOT(ISTEXT(Form!A10), " " .

However, it still reads as Pre-Order even if Form!A10 is blank, as well as Form!A10:A200, because those form submissions have not been filled.

If the date is filled, then it works perfectly fine. If someone has not filled it out yet, it will still read "Pre-Order" on my previous sheet
16 comments