Is there a way to track changes to the report builder criteria?

Chris A

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:

Paul Newcome

I don't think that it is possible to track who changes the Report Builder Criteria.

David Joyeuse

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. :)

Chris A

@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

David Joyeuse

@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...

Andrée Starå

Hi @Chris A

Here’s the solution I developed that David is referring to.

Thanks @ @David Joyeuse

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

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!

Paul Newcome

I don't think that it is possible to track who changes the Report Builder Criteria.