Automated Workflow - 3rd condition not working

DawnS

Morning All. I have created an automated workflow with 3 conditions to check if date fields are today and data is blank in certain cells. I have set 3 conditions up - but only 2 are generating the update requests - it can be any 2 of the 3 -

Each one of these has the action of request update.

The data sheet looks as follows and this morning I got an alert for the first 2 conditions but not the 3rd. If I complete the data in one of the conditions, the other one then works.

Do conditions stop once they have found an occurrence on a row - bit like formula and conditional formatting?

Thank you in advance.

Dawn

Andrée Starå

Hi Dawn,

Yes, the conditions basically work as an IF function and will stop when one is true.

Make sense?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer! 

DawnS

Hi Andrée - thank you for the info. I just need to understand a bit more. In my example data sheet I have the data fields marked in amber as the ones that should generate the alerts. These are all on separate rows and I received alerts for the first two conditions but not the third which is on row B (column feedback form date received and time). So if the first condition was true and then conditions stop, how would I have received the second condition alert and then why not the third? Many thanks for your help.

Regards

Dawn

Andrée Starå

Happy to help!

That is strange! At a glance, it looks ok.

Happy to take a closer look!

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

DawnS

Hi Andrée - yes I will share a copy shortly - thank you.

Andrée Starå

Thanks!

I'll take a look and get back to you!