using priority with Today function
I am trying to use priority symbols for two separate date columns to report "high for 60 days out, "Medium for 180 days out, and "Low" for everything else based off the two columns: Landlord Notice Date and Expiration Date, any help would be appreciated!
=IF([Landlord Notice Date]@row <= TODAY(60), "High", IF([Expiration Date (Current)]@row <= TODAY(60), "High", IF(AND([Landlord Notice Date]@row <= TODAY(180), [Landlord Notice Date]@row > TODAY(60), "Medium", IF(AND([Expiration Date (Current)]@row > TODAY(60), [Expiration Date (Current)]@row <= TODAY(180), IF([Landlord Notice Date]@row > TODAY(180), "Low", IF([Expiration Date (Current)]@row > TODAY(180), "Medium", "Low"))))))))
Answers
-
Try this out.
=IF(OR([Landlord Notice Date]@row <= TODAY(60), [Expiration Date (Current)]@row <= TODAY(60)), "High", IF(OR([Landlord Notice Date]@row <= TODAY(180), [Expiration Date (Current)]@row <= TODAY(180)), "Medium", "Low"))
If you want to use symbols you can which the column properties to symbols and select the red, yellow, green option and use the formula below
=IF(OR([Landlord Notice Date]@row <= TODAY(60), [Expiration Date (Current)]@row <= TODAY(60)), "Red", IF(OR([Landlord Notice Date]@row <= TODAY(180), [Expiration Date (Current)]@row <= TODAY(180)), "Yellow", "Green"))
-
@Devin Lee Devin, thank you for the input something is still off, its returning primarily High priority even with Blank date fields , which I think may be the issue.
=IF(OR([Landlord Notice Date]@row <= TODAY(60), [Expiration Date (Current)]@row <= TODAY(60)), "High", IF(OR([Landlord Notice Date]@row <= TODAY(180), [Expiration Date (Current)]@row <= TODAY(180)), "Medium", "Low"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!