Automated way of counting number of cell changes?
Hi all, we'd like to track the number of times a cell was edited in order to capture how many times we've moved out a date on any given project. I'm thinking this isn't possible with a formula, but has anyone found a solution with automation/integration or something else? We'd love to avoid updating this manually and the human error this can create.
Comments
-
Hi Jaye,
A possible workaround could be to use a third-party tool like Zapier or similar and copy the row when that specific cell changes.
Would that work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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.
-
Hi Andree, I could see that working and then pulling a countif range for the number of times that row appears! In effect it would should the number of times the cell was changed. Thanks, will try that.
-
Happy to help!
Let me know how it goes!
Best,
Andrée
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.
-
Hey there Andree, this doesn't seem to work for us. Are you super familiar with Zapier? I'm not, so unsure if I've just missed something. I'm only seeing the following trigger options:
- Updated Row
- New Row
- New Attachment
- New Comment
What would really help is "Updated Column" but that doesn't seem to be an issue. We have hundreds of in-flight projects and need a blanket way of saying, if any project's end date changes, copy that row to the sheet (at least if we're going the Zapier route). Thoughts? Thanks so much for your help - your name does not go unnoticed on these forums that's for sure!
-
Hey Jaye,
Thanks for your kind words! I'm always happy to help!
You would select Updated Row and then add a filter to choose what Zapier should continue with and then add an action to copy that row to another sheet.
Unfortunately, there isn't a function in Zapier that would trigger if the date is changed, but we could set it up so that if the date is after the original end date, it would trigger. We would probably need a way to keep the original end date in a helper column.
What do you think?
Best,
Andrée
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.
-
Hi Jaye,
How did it go? Did you get something set up?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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.
-
Thanks Andrée for checking in! I haven't had the opportunity to make this work yet but the way you've described it I think it will work well - we do have "planned end date" and "actual end date" columns so it could likely trigger of "actual" is after "planned". Thanks so much and will report back when I have time to work on this again!
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!