Add a flag formula

mcurrangalileo

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?

Carson Penticuff

Give this one a try:

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

Carson Penticuff

Give this one a try:

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

mcurrangalileo

Thanks, Carson!