Report Total Number of Times a Cell was Modified
Hi Smartsheet Community!
I need to be able to report on the total number of times one specific date field has been revised over the course of the project life cycle for trending purposes. I like that we have the ability to view the cell history by right clicking on the cell itself, but it would be nice if there was a way to easily report on the cell (or sheet) history activity without over complicating the process.
In my search for suggestions I did find a majority of replies that suggested using API or Zapier. I do not have the option to use either of these at the moment, so I am really looking for the least complicated workaround solution.
I found a suggestion posted by @Paul Newcome in the post copied below. I think I am going to try and see if I can do something similar with simply copying the modified date column to another sheet.
I also found the following suggestion posted by @Andrée Starå. A little more involved with formulas but I thought this was a good suggestion I'll keep in my back pocket.
Are there any other suggestions for creating a formula that would simply count the number of times one specific cell has been modified without having to create another sheet? I am all about the helper columns and think I am on my path to following Paul's lead of having alot of hidden columns for my reporting needs.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!