Hello all,
I'm currently having a sheet with the answers from one survey form (30 questions). The answers are YES/NO option, but then I would need to convert the YES and NO in 1 and 0. What I did (and maybe I overcomplicated myself) was to create 1 workflow per column. When a new row is created then this triggers the 1st workflow (in order to change the first column to 1 or 0) and when the row changes, then this can trigger the 2nd workflow, and so on. I'm having 30 columns, so I created 30 workflows but I'm receiving this message: "This workflow was triggered by at least 5 other workflows, which exceeds the maximum allowed. Please modify the workflows that are reacting to this one so they don't trigger each other. This workflow has been disabled." I already tried with some conditions to trigger the workflows, but I'm still receiving the same message. Is there an easier way to replace the YES/NO?
Many thanks!