How do I set an automation without a trigger or is there a workaround to create a trigger

Jennifer Roam · 08/27/20

Hello!

I am needing to set an automation to lock and unlock rows. I have the automation set to lock the row when it is changed from “open” to any other value. I need a time based function that will allow the cell to unlock a certain time period after it is locked by the first automation. Essentially I want to ensure that no edits are made for a select period of time (I am flexible with the amount of time but would like for it to be a day). But in order to get the rows that were locked to unlock there obviously needs to be a trigger. I added a column for modified date and tried to set it to run 1 day after when modified date is not today as a condition and then to have that run daily. However it doesn’t allow that automation to be run daily but only “when triggered”. Any suggestions would be appreciated.

Andrée Starå · 08/27/20

Hi @Jennifer Roam

Please have a look at my post below with a method I developed.

More info:

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work?

I hope that helps!

Be safe and have a fantastic day!

Best,

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

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

Andrée Starå · 08/27/20