Add a flag formula
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
-
Give this one a try:
=IF(AND(Submitted@row <= TODAY(-90), Submitted@row <>""), 1, 0)
Answers
-
Give this one a try:
=IF(AND(Submitted@row <= TODAY(-90), Submitted@row <>""), 1, 0)
-
Thanks, Carson!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!