Add a flag formula

edited 06/14/23 in Formulas and Functions

I'm looking to add a flag for when a item has been open for more than 90 days - for that I have the formula below which works:

IF(Submitted@row <= TODAY() - 90, 1, 0)

Where I'm running into issues though is if there is no date in the Submitted column, then the flag is turned on. I'm trying to have the flag only show when it's over 90 days open so I'd like there to not be a flag when the Submitted date is blank. I've been trying to use this formula below and it keeps kicking back as unparesable.

=IF(ISBLANK(Submitted@row),0), IF(Submitted@row <= TODAY() - 90, 1, 0)

What advice do you have?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!