# If Formula with Dropdown conditions

Options
✭✭✭✭
edited 12/09/19

I am trying to get an IF statement to check conditions of 3 dropdowns and based on those being true either add a specific value or do a calculation.  Below is what I am trying, but I am only getting it to populate N/A, no matter what the values entered are.  If the 3 that are entered below are true it should enter the value of \$467.00.

=IF([Visit Type]1 = "Temp Staff Aug", IF([Site Name and Number]1 = "Amgen France", IF([Sell Price]1 = [Sell Price]1 = "Engineer Day Rate", "\$467.00", "N/A")))

Tags:

• edited 08/07/18
Options

I think you will need to use IF(AND or IF(OR

=IF(AND(AND_expression1, AND_expression2, AND_expression3)IF_logical ecpression, value_if_True, value_if_false)

=IF(AND([Visit Type]1 = "Temp Staff Aug", [Site Name and Number]1 = "Amgen France", [Sell Price]1 = "Sell Price", [Engineer Day Rate]1 = 467), 467, 0)

the formula is in a result column, Results Column

• ✭✭✭✭
Options

Thank you, I will try it out

• Options

I just update my post I tested it and it seem to work.

• ✭✭✭✭
Options

I think you nailed it, thanks again

• ✭✭✭✭✭✭
Options

If that doesn't work, try taking out the 2nd IF statement.

=IF(expression1expression2, expression3), value_if_True, value_if_false)

• ✭✭✭✭
Options

Still getting an unparseable error, I included a screenshot below.

Here is formula, I am missing something...

=IF(AND_([Visit Type]1 = "Temp Staff Aug", [Site Name and Number]1 = "Amgen France",[Sell Price]1 = "Engineer Day Rate",[Column11]1 = 467), 467, 0)

• ✭✭✭✭✭✭
edited 08/08/18
Options

=IF(AND([Visit Type]@row= "Temp Staff Aug", [Site Name and Number]@row= "Amgen France", [Sell Price]@row= "Engineer Day Rate"), "467", "0")

Try that...

• ✭✭✭✭
Options

That did it!  Thanks!

• ✭✭✭✭✭✭
Options

Sure thing. Happy to help.

• edited 12/05/19
Options

May I also jump in on this topic...Paul Newcome can you help me with a child-parent dropdown formula? For QA testing, I want the parent to reflect the condition of any child. So if the child passes a test, the parent passes. But any fail for a child supersedes the pass of any child and fails the parent. See attached...appreciate the help!

• Options

An addendum to my query above, which isn't actually above yet...I'm halfway there with this:

=IF(COUNTIF(CHILDREN(), "Pass") > 0, "Pass", IF(COUNTIF(CHILDREN(), "Fail") > 0, "Fail"))

But I need "Fail" to supersede "Pass." Help??

• ✭✭✭✭✭✭
Options

Formulas read left to right, so if you just swap the order of the IF's, then you should be good to go...

=IF(COUNTIF(CHILDREN(), "Fail") > 0, "Fail", IF(COUNTIF(CHILDREN(), "Pass") > 0, "Pass"))

• Options

Thanks, Paul. Yes, figured that out (the order). Working like a charm now.

Cheers,

Suzanne

• ✭✭✭✭✭✭
Options
• Options

Hi Paul...Can we have IF statement to pick Contact (only one that I have) from drop down list?

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!