IF formula is not working as expected

Xochitl C.

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"))

Frank S.

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 S.

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.

Xochitl C.

https://community.smartsheet.com/discussion/comment/417210#Comment_417210

Thanks @Frank S. it worked!!