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

Find more posts tagged with

Formulas

logic

Accepted answers

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.

All comments

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!!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.