Reporting on Last Updated column

Angela Logie

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

itsnotbroken

The highlight cells function is not enough?

Do you want to watch EVERY column in the sheet?

Nick Korna

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!

Andrée Starå

Hi @Angela Logie

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!