Using =IF(AND) formula

Hello,

I'm trying to create a sheet summary formula that will return a "1" result if the following criteria are met: 1) the Sheet Summary field "Application Status" is showing "APPS ON HAND", and 2) the date in the sheet summary field "Oldest App on Hand" is more than five days prior to the current date. Otherwise, I want to result to be "0"

Here is my current formula and I am getting an #INCORRECT ARGUMENT error

=IF(AND([Application Status]# = "APPS ON HAND", [Oldest App on Hand]# < TODAY() - 5, 1, 0))

Thank you!

Find more posts tagged with

Accepted answers

KPH

You have the closing parenthesis for the AND after the values to return for the IF. If you move it to here, you should be fine:

=IF(AND([Application Status]# = "APPS ON HAND", [Oldest App on Hand]# < TODAY() - 5), 1, 0)

All comments

KPH

You have the closing parenthesis for the AND after the values to return for the IF. If you move it to here, you should be fine:

=IF(AND([Application Status]# = "APPS ON HAND", [Oldest App on Hand]# < TODAY() - 5), 1, 0)

Lindsay Scarey

Awesome, thank you! I knew it had to be some little mistake like that. It's working now!

KPH

Great news!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.