Reporting on Last Updated column
Looking to find a formula that works for reporting/counting the last updated column for:
- Updated in last 7 days
- Updated in last 30 days
- Updated in last 90 days
- Never updated
Answers
-
The highlight cells function is not enough?
Do you want to watch EVERY column in the sheet?
-
Hi @Angela Logie ,
For the not updated you'll also need to include a created date column to go with the updated (in the formula below these columns are referred to as [Created] & [Updated] respectively, but if you have different columns names just change them over.
The following formula should then give the result you'd like, with an additional result for over 90 days.:
=IF(([Created]@row - [Updated]@row = 0), "Never updated", IF(AND(NOT([Created]@row = [Updated]@row), (TODAY() - [Updated]@row) <= 7), "Updated in last 7 days", IF((TODAY() - [Updated]@row) <= 30, "Updated in last 30 days", IF(AND(((TODAY() - [Updated]@row) <= 90), (TODAY() - [Updated]@row) >= 30), "Updated in last 90 days", "Updated over 90 days ago"))))
Obviously you can change the text over if you want something different for the oldest. This should give a result something like this (the updated column has had to be fudged to manual entry for obvious reasons!):
Hope this helps; if you've any questions please don't hesitate to ask!
-
I hope you're well and safe!
Have you explored using Reports instead?
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!