Collect a date when row is taken off hold

Dakota Haeffner_N

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!

bisaacs

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)

bisaacs

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)