Sequential Approvals with Missing Contacts
I'm trying to build an automation that sends out approvals in sequence. If a contact column (1-3) is blank, it should skip to the next approver so the workflow can continue. As I understand the approval automation, it will run in sequence written, but if there's no contact assigned, then the workflow won't run or at least won't know who to send the approval to, and therefore "breaks" the flow. I'm curious if there's a better way to structure the sheet to account for these holes in the approval contact columns, or a clever workflow where I don't have to write out all conditional paths for every scenario. Appreciate your thoughts and feedback!