Help with IF(AND(ISBLANK statement

Options

Hey there, looking for help with this formula:

=IF(AND(ISBLANK([Orientation Appointment]3)), [HR RedCarpet Green Light]3=0), "Red", "Green")

Trying to get it to read a Red ball if "Orientation Appointment" cell is blank AND if "HR RedCarpet Green Light" cell is not checked, but I seem to be doing something wrong.


Thanks!

Answers

  • MCorbin
    MCorbin Overachievers Alumni
    Options

    You have an extra close parentheses after the Orientation Appointment piece. Try this:


    =IF(AND(ISBLANK([Orientation Appointment]3), [HR RedCarpet Green Light]3=0), "Red", "Green")

  • Christina Riley
    Options

    AH! Those darn parenthesis get me every time. Thanks!

  • Christina Riley
    Options

    Hmmm so the formula works but not the way I intend.

    If "Orientation Appointment" is filled in but the HR RedCarpet Green Light is not checked, it's showing green. I need both those conditions to be true for it to be green, but it seems to only be applying the logic to one condition and not the other.


    So BOTH the orientation needs to be filled in and the HR REdCarpet Green light checked for it to show green. What am I doing wrong?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!