Hi, is it possible to query the Activity Log w/functions to detect when a change to a cell was made?

Marc Roussel

Greetings,

We are working on a work intake tracker that has fields like [Project Create Date] and [Project State], among many others. We want to track how many days a Project State] has the value "Not Started". This calculation must stop once the [Project State] changes from "Not Started" to another state and only when this type of change happens. We plan to use the NETWORKDAYS to accumulate the #days each day the [Project State] stays "Not Started". We were thinking if there's a way to query the Activity Log (or cell history) programmatically to find out the event where [Project State] changed from "Not Started" to <some other state> then we could leverage that in our formula.

E.g.,

IF <event in Activity Log > ="Project State: Not Started to: <something else>", NETWORKDAYS([Project Create Date],<change date from Activity Log>)-1,NETWORKDAYS([Project Create Date] ,TODAY())-1

Andrée Starå

Hi @Marc Roussel

I hope you're well and safe!

I'd recommend setting up a workflow with the Record a date feature instead.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Marc Roussel

Hi again,

This is helpful. The challenge with creating a workflow is to capture the exact change of [Project State] from "Not Started" to something else as opposed to capturing all changes made to [Project State]. I'll explore my options there further, thanks.

Andrée Starå

@Marc Roussel

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

sweta22

Hi @Andrée Starå

Is it possible to query the Activity Log though? I want to note the latest value a cell had before it is changed to some new value. I think we can take it from only the activity log but, not sure about the approach.

It will be helpful if you can suggest any workaround!