Are Automations Reliable?
I apologize in advance if I am violating any community guidelines by asking this, but I'd like to survey some experienced users.
Are automations reliable enough to trust for essential workflows?
I have built automations for recording dates, moving rows, copying rows, changing cell values, etc. In almost every type of automation, at some point it stops running and I have to go back and manually update things. For example, right now, I have a sheet with 86 rows where a date was not recorded at the end of a process. Yet I have hundreds of other rows where the date was recorded correctly. Because we use this data recording as a metric for productivity in the process, I now need to manually audit every row and manually update the date.
This is not a vent or a rant. I am genuinely interested to learn if my experience is unique or common, and if there is a workaround or better practice that I can follow.