formula for status within last 365 days

I am trying to figure out a formula to use the status (red, green dots) to show if the document is within the last 365 days based on a last revision column.
Trying to track program document review. So if the last review column is within 365 then a green dot, if greater than a red dot.
Hope this makes sense.
Any help would be appreciated. THANKS
Best Answers
-
Hi @Tammy Luther ,
Set up your column as a3 color ball symbol. Enter this formula:
=IF(today()<DATEONLY([modified]@row) +365, "green", "red")
Work for you?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
worked perfect - TY
Answers
-
Hi @Tammy Luther ,
Set up your column as a3 color ball symbol. Enter this formula:
=IF(today()<DATEONLY([modified]@row) +365, "green", "red")
Work for you?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
worked perfect - TY
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!