Formula help

Options
JKremer
JKremer ✭✭✭✭
edited 09/13/23 in Formulas and Functions

I need assistance with a formula.

Trying to create if/and statement for a checkbox.

=IF(AND([Trigger for Parent]@row = TODAY(), [Submission Status]@row = ISBLANK, 1, 0))

If the Trigger for Parent column = today

AND

the Submission Status column ISBLANK

Check the box

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!