Formula help

JKremer

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

David Tutwiler

You are missing parentheses on your ISBLANK and a reference. It should look like:

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