# IF AND with multiple conditions

Options
✭✭✭✭✭

I've got a doozie for you all.

Luckily, I'm partially there.

I want to run a function with the following conditions:

If Task = C or GM, and JXDN = US, then return Trademark/Domain General - US

If Task = E or ACQ, and JXDN = US, then return Trademark Disputes - US

If Task = P, and JXDN = US, then return Trademark Prosecution - US

If Task = C or GM, and JXDN = not US, then return Trademark/Domain General - Foreign

If Task = E or ACQ, and JXDN = not US, then return Trademark Disputes - Foreign

If Task = P, and JXDN = not US, then return Trademark Prosecution - Foreign

The current formula I am using is getting me the first part of my desired outcome, without returning the "US" or "foreign" part. It is as follows:

I am basing my design off of an already existing Excel formula:

I don't think Smartsheet plays well with the "&" in this Excel formula

Can someone point me in the right direction?

Tags:

• ✭✭✭✭✭✭
Options

Hello @Kayla Q

Here is the formula you requested

Is there a chance that your JXDN field could be blank? If yes then you will need this formula instead

Do either of these work for you?

Kelly

• ✭✭✭✭✭✭
Options

Hello @Kayla Q

Here is the formula you requested

Is there a chance that your JXDN field could be blank? If yes then you will need this formula instead

Do either of these work for you?

Kelly

• ✭✭✭✭✭
edited 07/09/22
Options

Try this

1. My first If check looks at US/Non-US and
2. Then I check the case for C or GM and then E or ACQ..
3. I assume what is left over is the "P" condition so it doesn't need to be checked and is assumed to be everything else

Then just put it all together

Brent C. Wilson, P.Eng, PMP, Prince2

Facilityy Professional Services Inc.

http://www.facilityy.com

• ✭✭✭✭✭
Options

Thanks @Kelly Moore! That worked!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!