Calculation with multiple conditions - if statement?

I'm calculating the number of days between my due date and today. I'm trying to make this calculation based on a separate column NOT being certain conditions. I have successfully done the following:

=IF(Stage@row <> "9 Released", [Due Date-Plan]@row - TODAY())

But I want this calculation to also exclude those items in the Stage column that are "X On Hold" and "Z Rejected".

I've tried below, which doesn't work.

=IFs(Stage@row <> "9 Released", Stage@row <> "X On Hold", Stage@row <> "Z Rejected", [Due Date-Plan]@row - TODAY())

Suggestions?

Find more posts tagged with

Accepted answers

Mark Cronk

Hi @Angie Little ,

Try:

=IF(AND(Stage@row <> "9 Released", Stage@row <> "X On Hold", Stage@row <> "Z Rejected"), [Due Date-Plan]@row - TODAY(),"")

Mark

All comments

Mark Cronk

Hi @Angie Little ,

Try:

=IF(AND(Stage@row <> "9 Released", Stage@row <> "X On Hold", Stage@row <> "Z Rejected"), [Due Date-Plan]@row - TODAY(),"")

Mark

Angie Little

Thanks! That worked!

Mark Cronk

Excellent. Glad you found a solution. Thank you for contributing to the community. Mark

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.