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
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!