Is there a formula to count how many times a specific column was changed?
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?
Best Answers
-
Hi @tcraig87446
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!
-
@tcraig87446, if you were unable to find the post @David Joyeuse is referencing, here's the direct link:
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
Answers
-
Hi @tcraig87446
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!
-
@tcraig87446, if you were unable to find the post @David Joyeuse is referencing, here's the direct link:
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
Help Article Resources
Categories
Check out the Formula Handbook template!