Check a box based on another cell not being blank

Hello!
Looking for a way to check a box in column 2 based on column 1 not being blank.
I've found variations on this theme, but nothing that quite gets me what I am looking for.
Column 1 = Delivery Date
Column 2 = check box
I want column 2 to "automatically" be checked if a column 1 has a date populated / is no longer blank.
I could also do this (if easier) if there is something in column 1 (#no match) until column 1 has a date, but I'd prefer not to do this if the above is possible.
Thanks in advance for your assistance!
Best Answer
-
There's two ways to do this, depending on whether you want the box to be checked when there's a date, or is not blank in Delivery Date.
Both solutions are constructed the same way anyway.
First, check the box when there's a Date in Delivery Date and not checked if it is blank or not a date:
=IF(ISDATE([Delivery Date]@row), 1, 0)
Second, check the box when Delivery Date has a date or something else, and thus is not blank:
=IF(ISBLANK([Delivery Date]@row), 1, 0)
Pick the one that suits you better :)
Hope it helped!
Answers
-
There's two ways to do this, depending on whether you want the box to be checked when there's a date, or is not blank in Delivery Date.
Both solutions are constructed the same way anyway.
First, check the box when there's a Date in Delivery Date and not checked if it is blank or not a date:
=IF(ISDATE([Delivery Date]@row), 1, 0)
Second, check the box when Delivery Date has a date or something else, and thus is not blank:
=IF(ISBLANK([Delivery Date]@row), 1, 0)
Pick the one that suits you better :)
Hope it helped!
-
Perfect - thank you so very much for the quick response!!!
-
To add to Davidβs excellent advice.
Here's a third option.
=IF([Delivery Date]@row="",1,0)
I hope that helps!
Be safe and have a fantastic weekend!
Best,
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
β Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi @AndrΓ©e StarΓ₯ !!!
To carry on with this theme, can we do the same thing, but have it based on (2) sets of data?
Check Box if both instances below are applicable:
Delivery Date = not blank + Route Mapped = not blank
Thanks as always for your assistance!!!
-
@AndrΓ©e StarΓ₯ great answer! Is there a way to do this if the requirement is multiple cells on the same row are not blank? ie Check box if Team 1 = not blank + Team 2 = not blank +Team 3 = not blank
Help Article Resources
Categories
Check out the Formula Handbook template!