I have a board with about 100 groups. Each group has 10-30 items. I’d like to know the last time any item in a group was updated (which, to me, means that the group was updated). The only option I’ve found is using the Last Updated column and then creating a bar chart that shows the Max value of the Last Updated column by group. However, that doesn’t really work because of the volume of groups and items so the bars are squished together and difficult to read. Is there a creative automation or something that anyone has done to accomplish this? Otherwise, I’m stuck manually reviewing all rows. I’d much rather have an exception report. Thanks!
Welcome to the Community!
In addition to using the Last Updated column, you might like to use a feature from our monday.labs menu.
This is where you can find all of the features that are still in beta and activate them for your account.
We have a feature called ‘Highlight new board changes’.
This feature will visually highlight any data that has changed since your last visit to the particular board.
This allows you to easily find the most recent changes to your board.
You can find the monday.labs menu here:
I hope this helps! Remember to mark as solved if this answers your question 
Best,
Dani
Hi @amy.westlake!
Was the previous answer helpful for you?
If so, please don’t forget to mark it as the solution so other users can easily find it, and to close this thread 
If not, feel free to ask any additional questions you have!
Best,
Dani
Hi Dani -
Unfortunately not. That was a very helpful tip for some other stuff but I’m still looking for a way to easily identify the last time any item in a group was updated without having to look through every item. Ideally, I’d love to have a report that shows only those groups where all items haven’t been updated in the past 2 weeks.
If there are other suggestions, please let me know.
Thanks!
Amy.
Hi @amy.westlake - you could try to visualize this in a chart perhaps (its not perfect). Basically a simple stacked bar chart where x-axis = Last Updated, stack by = Group.
You could then set a filter on Last Updated to the past two weeks?
Thanks,
Mark
If you are on the Pro Plan or higher, then you should also have access to The Formula Column, which could help offer a workaround!
My idea would be that you build a formula that counts the number of days between today and the date within The Last Updated Column . If that number is over 14 (aka two weeks), then it will output that the item needs updating and if not, it won’t show anything:
IF(DAYS(TODAY(),{Last Updated#Date})>=14, "Needs Updating", "")
You can then use The Board Filters to make a view/chart that only shows the items that require updating (aka items that have not been updated within the last two weeks):
Additionally, you may find some helpful information in one of our other formula support articles:
-
The IF Function (If you’re looking to make conditional output based on other values on your board).
I hope this helps! Remember to mark as solved if this answers your question 
Cheers,
Jenna
We haven’t had any responses on this thread for a while so I wanted to check in and see if you needed any more assistance here?
If so, please don’t forget to mark it as the solution so other users can easily find it, and to close this thread
If not, feel free to ask any additional questions you have!
Best,
Dani
Hey @amy.westlake!
Here’s a summary of the different solutions proposed throughout the thread:
We’ll close this out with this as the answer so people can easily jump to the one they think best fits their solution but if you have further questions feel free to DM me or Dani or add a new post!
Cheers,
Jenna
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.