I need help with a IF formula, how to return a value and ignore rest of formula if a box is checked?


I have a formula started in the Day 1 Delay column to return various values if the duration of delay is between certain numbers however, if the on hold or cancelled columns are checked. I'd like a value to be returned, I'm assuming it would need to ignore the formula is the box is checked and only return "On hold" or "Cancelled" in the Day 1 delay column. Thoughts on a formula?

Best Answer

  • JamesB
    JamesB ✭✭✭✭✭✭
    Answer ✓

    @Amy Merrill

    Since the Cancelled or On Hold columns are the first consideration in your statement, start your if off with this check.

    If(OR(Cancelled@row=1,[On Hold]@row=1),'Your Value if True', 'Your Formula here if False')


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!