Collect a date when row is taken off hold
Hello,
I'm looking for a method through automations to collect a date when the status changes from On Hold to anything else. I tried the screenshot below but I'm not getting the intended result. I have another automation collecting a date when the row gets put on hold as well.
Any suggestions are appreacited!
Best Answer
-
Hey @Dakota Haeffner_N,
Maybe try creating a helper checkbox column that gets checked when the status is changed to "On Hold" by using =IF(Status@row = "On Hold", 1, 0), then in the automation workflow, change the Trigger block to "When helper checkbox column changes to "Unchecked" record the date.
Something like that might work, otherwise there's no way for the system to recognize when the Status is being changed from On Hold to something else
EDIT: I just tried this and it seems to work as intended (although it does take either a refresh of the sheet or exiting/reentering the sheet to record the date)
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
Answers
-
Hey @Dakota Haeffner_N,
Maybe try creating a helper checkbox column that gets checked when the status is changed to "On Hold" by using =IF(Status@row = "On Hold", 1, 0), then in the automation workflow, change the Trigger block to "When helper checkbox column changes to "Unchecked" record the date.
Something like that might work, otherwise there's no way for the system to recognize when the Status is being changed from On Hold to something else
EDIT: I just tried this and it seems to work as intended (although it does take either a refresh of the sheet or exiting/reentering the sheet to record the date)
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives