Hi, is it possible to query the Activity Log w/functions to detect when a change to a cell was made?
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
Answers
-
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!
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 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.
-
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!
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.
-
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!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives