Automation Condition Not working

Options

Hey all,

I set up an automation to request an update if one field is blank and if another field is not a specific list of departments and I got an email this from someone in that department saying they got an email anyways.

Can you take a look at the below screenshots and tell me if I'm missing something?

Here is the automation:

Here is the email they received:

I've check to make sure it is exact. No spaces or other options in the 'is not one of' field.

Thanks!

Tags:

Best Answer

  • Ella
    Ella ✭✭✭✭
    Answer ✓
    Options

    @Dakota Haeffner It seems that Week 1 QA is triggering it due to being blank for that particular department.

    Can you split your current set up into 2 separate conditions and test it, but make "Is not one Of" your first condition so that the worklfow first filters out these departments and then add that Week 1 QA should be blank?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!