Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
We have multiple automations that were previously working that are no longer triggering and I can't figure out why. Here's one example:
It was last triggered over 2 weeks ago but there are 53 rows that have an updated status meeting the criteria that have not moved over to the Archive sheet. Any idea what might cause this not to work?
As mentioned we have multiple change cell value, copy row, and move row automations that use to run but have stopped sometime in the last week or two. Is anyone else having similar issues? Is this a bug in the system?
Is it possible that the sheet you are moving them to is full? This help article defines limits:
Hope this helps!
@Chelsea.McCulley You could also try manually running the workflow on one row to see if that works to narrow down the problem:
@ker9 No, the sheet is not full. Running it manually ignored the triggers so it wouldn't show why this isn't working anymore. Thank you for the questions though.
@Chelsea.McCulley Presuming the workflow does not have any type of error message, I suggest temporarily changing the trigger to run once a day at a specific time to see if that works. The time does not need to be at 4am but could be around the time you update the trigger.
Hope this helps with diagnosis of problem.
So it turns out automations cannot be triggered by any cell that is or is referencing a cell link, including triggering when rows are simply added. I had to create multiple scheduled automations to run each hour instead.
