HELP - Nested IF Statement

refogleman91066

Having trouble with the nested if statement.  I made sure to spell my columns EXACTLY as they are on the sheet.

First, here is my criteria:

1) If Dev Mgr Approval is Submitted, then show Pending Mgr Approval

2) If Dev Mgr Approval is Declined, then show Declined

3) If BOT Approval Req? is Yes, then show Pending BOT Approval

4) If PC RFA Application Number is greater than 0, then show Complete/Archived.

5) If none of the above, then show In Process.

 

Here is my formula, but getting the #UNPARSEABLE error:

=IF(([Dev Mgr Approval]1 = "Submitted", "Pending Mgr Approval", IF([Dev Mgr Approval]1 = "Declined", "Declined", IF([BOT Approval Req?]1 = "Yes", "Pending BOT Approval", IF([PC RFA Application Number]1 > 0, "Complete/Archived", "In Process")))))

Where am I going wrong?

Thanks all!

Andrée Starå

Hi,

At a glance, you got one parenthesis too many at the beginning of the formula.

Did it work after you removed that one?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

I agree with Andree. One too many in the beginning. There is also one too many closing parenthesis at the end as well.

refogleman91066

It worked! Thanks Andree and Paul - just couldn't see it staring at it so long.

refogleman91066

An additional question - there is a form related to this sheet where users input new info for approvals.  However, when the new row is inserted at the top, the Status column is reverting to an OLD status.  It was previously a dropdown column, but I changed it to a Text/Number - I tested and it still reverts to the old status option.  (Should be Pending Mgr Approval, but automatically populates Pending JA Approval.) So bizarre. 

Paul Newcome

Do you have a formula in the Status column?

 

Also check your form to see if this is a default value for the field.

refogleman91066

Yep, that column snuck its way onto the form as a hidden field.  I deleted it, tested, and it fixed the problem.  Thanks! 

Paul Newcome

Excellent! Happy to help! 

Andrée Starå

Happy to help!

Easy to miss!