Is there a formula to count how many times a specific column was changed?

tcraig87446

I'd like to count how many times the data in one sheet column is changed, so I can feed that into a productivity dashboard that shows how many rows a user works daily/monthly (based on a count of each time the data in that specific column is changed).

Right now I get that through workflow alerts that are emailed to me-- they trigger daily based on that one specific column change, and a row count is displayed at the top of each email, but then I have to manually type that into a sheet for my dashboard.  Is there a sheet formula that can help me?

David Joyeuse

Hi @tcraig87446

https://community.smartsheet.com/discussion/comment/261828#Comment_261828

This subject is what you're looking for. A simple copy automaton then a COUNTIF on the sheet will do the trick :)

Hope it helped!

Genevieve P.

@tcraig87446, if you were unable to find the post @David Joyeuse is referencing, here's the direct link:

https://community.smartsheet.com/discussion/71064/report-total-number-of-times-a-cell-was-modified#latest

David Joyeuse

Hi @tcraig87446

https://community.smartsheet.com/discussion/comment/261828#Comment_261828

This subject is what you're looking for. A simple copy automaton then a COUNTIF on the sheet will do the trick :)

Hope it helped!

Genevieve P.

@tcraig87446, if you were unable to find the post @David Joyeuse is referencing, here's the direct link:

https://community.smartsheet.com/discussion/71064/report-total-number-of-times-a-cell-was-modified#latest