Problem with nested IF statements

Kristin N
Kristin N ✭✭
edited 12/09/19 in Formulas and Functions

I'm having a problem with the following statement. Each IF statement works independently, but not when nested. Can't figure out what's wrong.

=IF(AND(Budget1 >= 100000, [Executive Sponsor approval2]1 = "Approved", [Finance Approver approval]1 = "Approved"), "Yes", =IF(AND(Budget1 < 100000, [Executive Sponsor approval]1 = "Approved"), "Yes", "No"))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!