Hi - I am using Smartsheet to manage our cutover plan for a software deployment. I have 2 columns that populate a Yes/No value automatically based on a formula calculation. Those columns are called 'Trigger Date' and 'Trigger Time Comparison'. The 'Trigger Time Comparison' is always the last column to flip to Yes, so I set this as the trigger for my automation. The automation checks to see if specific criteria are met. If they are - then the automation flips the Task Status for the impacted row to Completed.
I have been working at this for hours and have tried doing countless refreshes/saves after tasks have flipped to Yes in the Trigger Time Comparison column. The automation never runs on its own. The only way I have gotten it to work is by manually triggering it. Am I doing something wrong here?
For additional context - the trigger date and trigger time columns use date in the sheet to determine if a certain point in time has reached. Our sheet has a finish date column, so if today's date is greater than or equal to the finish date, this column updates the value to Yes. The Trigger Time column is a bit more complex: I feed into a cell in the Smartsheet what the current time is through a Google Sheets/Zapier integration. This gets updated every 3-4 minutes. My sheet then takes a Finish Time column, dissects and calculates for the number of minutes and compares that to the number of minutes attached to the current time. If the current time in minutes is greater than or equal to the finish time, then this flips the Trigger Time Comparison column value to Yes.