Is there a way to track changes to the report builder criteria?
I would like to see changes to the report criteria that determines what data is pulled into the report. I have a few different admins that have access to a report. What the report pulls in from the sheets keeps changing, and I want to see who is making the changes. I don't see the option under the Activity Log.
Edit since I don't think I was very clear above. I'm trying to track changes made in the below screen:
Best Answer
-
I don't think that it is possible to track who changes the Report Builder Criteria.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Hi @Chris A
Did you try to add the automated column "Modified by" to your sheet? This will display who made the last change on the row.
Add this column to your sheet and display it in the report. :)
-
@David Joyeuse , thanks for your response. That will show changes to the underlying sheet the report is pulling from, but I'm looking for changes to the Where, Who, What, When fields in the report builder.
Chris
-
@Andrée Starå got some kind of solution that could help here. It's about automatically copying rows to another sheet each time there's a modification in the row (whatever it is). Adding automated columns "date modified" and "modified by" would give you the when and who.
Regarding What & Where is another problem though...
-
Hi @Chris A
Here’s the solution I developed that David is referring to.
Thanks @ @David Joyeuse
More info:
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 help the Community by marking it as the accepted answer/helpful. 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.
-
I don't think that it is possible to track who changes the Report Builder Criteria.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!