Problem with nested IF statements
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"))
Comments
-
Hi Kristin,
Try removing the = before the second IF.
Did it work?
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you! That worked!
-
Excellent!
Happy to help!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!