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.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!