Check a box based on another cell not being blank


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!