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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!