Help with nested IF AND statements

I am attempting to create a string of IF AND statements for the attached image. I created the first statement without issue

=IF(AND([Vendor of Choice]@row = "ARTEMIS", Funding@row = "Confident"), "Commit"

but when I added the second set of statement to the I received an INVALID OPERATIONS message.

=IF(AND([Vendor of Choice]@row = "ARTEMIS", Funding@row = "Confident"), "Commit", =IF(AND([Vendor of Choice]@row = "ARTEMIS", Funding@row = "Neutral"), "BestCase"))

What am i doing wrong?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!