I need to formula to show if my application is more than 90 days old
Example - I have a Today column, but need to know if Application fee invoice received date is more than 90 days from the Application start date , even if there is no application fee invoice received date. How do I show that in a formula?
Answers
-
I can try to help you out but just to clarify..
Would you like to be alerted at 90 days?
Would a want a condition that highlights the cell yellow after 90 days?
Would you want another column that would show a symbol after 90 days, like a flag?
-
Hi Jeff- I'd love it if there was a condition for 90 days that was red if 90 days
-
You could make 2 conditions using the application start date column and making two conditions like the example below. Just make sure you put them in order by priority otherwise the top will override the other. You can also select multiple cells that will change to red.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!