Formula help

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

Find more posts tagged with

Formulas

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)

index match using multiple critieria
Hello, I want to use a formula using INDEX/ MATCH Function using multiple criteria to get a single value I am trying to get a value of Column Description from File 2 based on matching Source System ,Table name and Attribute Field Index ( as the column names may be different ) The formula Im using gets me an INVALID…
How can I use Conditional Formatting for date in the past or future when a formula created the date
Hi Everyone, Thank you for your time in reading this. How can I use Conditional Formatting for date in the past or future when a formula created the date? The black columns are different dates generated. The 2 yellow columns are then selecting the relevant date based on different criteria. The white columns are me trying…
Auto Check a box after 24 hours
I have tried to get smartsheet to auto check a box 24 hours after a row is created and column "Task Started" is not checked. =IF(AND([Task Started]@row <> 1, TODAY() - Created@row >= 1), 1) This returns #UNPARSEABLE. Any help would be appreciated.