For one of my sheets, when someone submits a request through a form, I have some rules that assign approvers, and also some rules that assign the number of approvers. These always work fine. Okay, as one example, let’s suppose the number of approvers is just one. I have a Change Status rule like this: When rows are added or changed, when First_Approver changes to <Any Value>, run workflow when triggered, where Number of Approvers is equal to 1, change cell value Status to Complete. The problem is this rule (and the similar rules for up to 5 approvers), does not always trigger and make it Complete. It works most of the time, but not all of the time. I am not having a similar problem with any of my other rules in the sheet. Any suggestions?
🤔