Help With Adding More Conditions in Current IF Formula

Hi everyone,

I am currently struggling to add more conditions to my current formula. The formula is:

=IF('Department 1'[Approval Response]="Pending" && 'Department 1'[Past Due/Scheduled]="Past Due",1,0)

I want to add two more conditions to the approval response: "In Process" and "On Hold", while keeping the second half of the formula. Basically, if the approval response is either pending, in process, or on hold, and if it is past due, then it would be marked as 1. If not, then 0.

Any and all help is greatly appreciated!

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

Paul Newcome

Are you currently getting any errors with your current formula?

An Nguyen

Not with the above formula, but I have been getting errors trying these out:

=IF('Department 1'[Approval Response]="Pending"," In Process", "On Hold" && 'Department 1'[Past Due/Scheduled]="Past Due",1,0)

=IF('Department 1'[Approval Response]="Pending"="In Process"="On Hold" && 'Department 1'[Past Due/Scheduled]="Past Due",1,0)

=IF('Department 1'[Approval Response]="Pending", IF('Department 1'[Approval Response="In Process", IF('Department 1'[Approval Response]="On Hold" && 'Department 1'[Past Due/Scheduled]="Past Due",1,0)))

Paul Newcome

What program are you working in? A formula like the one in your original post should be throwing errors in Smartsheet.

An Nguyen

Oh, I apologize. Admittedly, I am using Power BI, not Smartsheet, but I figured it was still applicable considering the information in my table is connected to my Smartsheet.

Paul Newcome

The formula syntax is very different between Smartsheet and Power Bi. I've never used Power Bi, so unfortunately I am unable to help.

@Andrée Starå Do you have any experience with formulas in Power Bi?

Andrée Starå

@An Nguyen

@Paul Newcome

Hi An & Paul,

Unfortunately, I haven't had much experience with formulas in Power BI.

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

Well bummer. Hmm...

@Genevieve P Do you or anyone you are able to tag have any experience with this? I don't even know where to point for Power BI specific help.

Genevieve P.

Hi @An Nguyen

Microsoft has a website dedicated to Power Bi documentation - I would suggest that this might be a better place to search: https://docs.microsoft.com/en-us/power-bi/ .

This page has an example of an If statement in Power Bi: https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns

Paul Newcome

Thanks @Genevieve P! I was going to end up looking it up on Google at some point today to see if I could find a resource. Haha.

Genevieve P.

@Paul Newcome That may or may not have been exactly what I did... 😬

Paul Newcome

Haha. No shame in using your resources, and Google counts as a resource.

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.