Sign in to join the conversation:
Hi,
I would like to present in report only rows which some of the cells has changed (Status, Due date, comments).
Is there a formula to track cell changes?
Thanks
Hi Michal,
Unfortunately, it's not possible at the moment, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
As a workaround, you might use the Modified column and show the columns that you want to see in the report.
Would that work/help?
How can I do that?
Happy to help!
I'll write something up later today.
We could add the Modified as a criterion in the Report Builder and select what you want to include.
For example, we could select in the last seven days, and that would show everything that's modified over the last seven days. Then we'd add/remove so only the columns that you want to see would be included in the report and use the feature called Highlight Changes to highlight what has been changed in the last seven days.
Would that work?
We changed from an enterprise licence to specific accounts. I have a licence and setup a workspace for our global team to edit and collaborate across various sheets. I granted editor can share rights to all non licensed members and shared the publish link with them. This has worked well and allowed them to edit cells,…
This is pulled from a column of responsible person. Why does it display email and not name. How do I correct?
Hi! I have a sheet that has two form that feed into it. This is to report on Closures due to Staffing, Weather, and Facilities. One team submits closures for Staffing and Weather, while another team only submits Facilities. When I created this set up I have it so the one team gets asked "Reason?" then they can select…
