Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Flagging Red using two conditions

Options
Tasnia
Tasnia
edited 10/11/17 in Archived 2017 Posts

Desperately trying to find a formula that does this: if due date is past and checkbox is blank then flag red in Symbol column

For Row 15, tried this but it is not parseable.

I used this formula in the Flag column

=IF(AND([Checkbox]15 < 1,TODAY()>[Finish]15)1)

says UNParseble

Comments

This discussion has been closed.