IF formula is not working as expected

I'm sure I'm doing something wrong with this formula, but I can't figure out :(

Any help is much appreciated!!

I'm trying to add a text to the column "Dispute", so if the # of days in the "Days from Audit" column is equal or higher to 10 text will be "Dispute not applicable" or if the # of days in the "Days from Audit" column is equal or lower than 9 the text will be "Proceed with Dispute Form"

This is the formula I have:

=IF([Days from Audit]@row < "9", "Proceed with Dispute form", IF([Days from Audit]@row >= "10", "Dispute not applicable"))


Best Answer

  • Frank S.
    Frank S. ✭✭✭✭✭✭
    Answer ✓

    Greetings @Xochitl C. ,

    Based on what I can see, you do not need the parenthesize around the numbers in your if statement.

    Please try the following formula and see if this works correctly for you:

    =IF([Days from Audit]@row < 9, "Proceed with dispute form", IF([Days from Audit]@row >= 10, "Dispute not applicable", ""))

    I hope this helps and have a great day.

    Frank Smith, PMP

    Assistant Director | IT Special Projects Mgr.

    Oregon Parks & Recreation Department

    If my response helps, please mark it as an accepted answer. 😎


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!