Issue with IF AND formula

=IF(AND([Engagement Phase]@row = "COMPLETED", [Production Status]@row = "Production Ineligible"), 0, 1)

The formula is not working completely. I think i need to add an additional clause/check.

Engagement Phase dropdown column with "In progress", "On-hold", "completed" etc statuses.

Production status column with values "In Prod", "Prod Ineligible" etc

Conversion column - which needs to set to 0 for Prod Ineligible - in order to not be counted in Total SUM.

The problem is that if the Engagement Phase is any other status meaning IN Progress or on hold, then the above formula is counting it as Conversion Eligible. As it puts a 1 in conversion eligible column.

I need to be like only for completed engagements that have a product in eligible then conversion eligible is 0. So any other engagement phase other than completed - conversion eligible is still 0.

Find more posts tagged with

Accepted answers

All comments

Sameer K

Are you sure the values you are comparing in your AND function are exactly the same (case too)? For example, your drop down values are "COMPLETED" and "Completed" or "Production Ineligible" and not "Prod Ineligible'?

keesuri25

No the column names are as in the formula. I was short cutting in the message above.

=IF(AND([Engagement Phase]@row = "COMPLETED", [Production Status]@row = "Production Ineligible"), 0, 1)

Now if the Engagement Phase is "In Progress" and Production Status is in Production - It sets 1.

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.