Nested IF giving me an Unparseable error

Jennifer Tillman

I am trying to create buckets of product go-live dates using the Nested IF formula. When I only had 4 buckets, it worked perfectly. When I added 3 more buckets, I cannot get it to work. Here's the formula:

=IF([Workdays to Go-Live Target]1 < 0, "Past Go-Live Target", IF ([Workdays to Go-Live Target]1=<7, "1 Week", IF([Workdays to Go-Live Target]1=<14, "2 Weeks", IF ([Workdays to Go-Live Target]1=<21, "3 Weeks", IF([Workdays to Go-Live Target]1 =< 30, "30 Days", IF([Workdays to Go-Live Target]1 =< 60, "30-60 Days", IF([Workdays to Go-Live Target]1= > 61, "60+ Days", "TBD")))))))

This is due tomorrow! Can anyone help me figure out what I am doing wrong? BTW- The original formula did not include = so I removed those and still got the error.

Thank you in advance for any assistance you may offer!

Zachary Mitchell

Hi Jennifer,

Try using @row in your formula ex: =IF([Workdays to Go-Live Target]@row < 0, ""). This may solve your problem.

-Zack Mitchell

Jennifer Tillman

Hi Zack,

Thank you very much for your suggestion. I tried it but I still get the same error. Did I type it in correctly?

=IF([Workdays to Go-Live Target]1 @row < 0, "Past Go-Live Target", IF ([Workdays to Go-Live Target]1 @row=<7, "1 Week", IF([Workdays to Go-Live Target]1 @row=<14, "2 Weeks", IF ([Workdays to Go-Live Target]1 @row=<21, "3 Weeks", IF([Workdays to Go-Live Target]1 @row =< 30, "30 Days", IF([Workdays to Go-Live Target]1@row =< 60, "30-60 Days", IF([Workdays to Go-Live Target]1 @row= > 61, "60+ Days", "TBD")))))))

Andrée Starå

Hi Jennifer,

@Jennifer Tillman

Try something like this. (You had the row number and a space in the formula still)

=IF([Workdays to Go-Live Target]@row < 0, "Past Go-Live Target", IF ([Workdays to Go-Live Target]@row=<7, "1 Week", IF([Workdays to Go-Live Target]@row=<14, "2 Weeks", IF ([Workdays to Go-Live Target]@row=<21, "3 Weeks", IF([Workdays to Go-Live Target]@row =< 30, "30 Days", IF([Workdays to Go-Live Target]1@row =< 60, "30-60 Days", IF([Workdays to Go-Live Target]@row= > 61, "60+ Days", "TBD")))))))

Did that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jennifer Tillman

Thank you, Andrée. Sadly, it did not work but I appreciate the help!

Andrée Starå

Happy to help!

I'd be happy to take a quick look!

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Paul Newcome

There is a space after the second and fourth IF's. The arguments need flipped (<= and >= instead of =< and =>), and there is a space between the arguments in the last set. Here it is with all of that corrected. See if that works...

=IF([Workdays to Go-Live Target]@row < 0, "Past Go-Live Target", IF([Workdays to Go-Live Target]@row <= 7, "1 Week", IF([Workdays to Go-Live Target]@row <= 14, "2 Weeks", IF([Workdays to Go-Live Target]@row <= 21, "3 Weeks", IF([Workdays to Go-Live Target]@row <= 30, "30 Days", IF([Workdays to Go-Live Target]1@row <= 60, "30-60 Days", IF([Workdays to Go-Live Target]@row >= 61, "60+ Days", "TBD")))))))

Andrée Starå

@Paul Newcome Good catched! 😉

Jennifer Tillman

Thank you! Sadly, this did not work. I think I may be too ambitious!

Andrée Starå

@Jennifer Tillman

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Paul Newcome

@Jennifer Tillman What do you mean it "id not work"? Are you getting an error or an unexpected output?

Jennifer Tillman

Sorry, the message was "it did not work", the error message is #UNPARSEABLE

Andrée Starå

@Jennifer Tillman Can you share the formula you have now and a screenshot?

Paul Newcome

@Jennifer Tillman Found it...

In your 6th IF statement where the output is "30-60 Days", there is a combination of a row number and an @row reference. Try the below (bold is where the row number was removed from).

=IF([Workdays to Go-Live Target]@row < 0, "Past Go-Live Target", IF([Workdays to Go-Live Target]@row <= 7, "1 Week", IF([Workdays to Go-Live Target]@row <= 14, "2 Weeks", IF([Workdays to Go-Live Target]@row <= 21, "3 Weeks", IF([Workdays to Go-Live Target]@row <= 30, "30 Days", IF([Workdays to Go-Live Target]@row <= 60, "30-60 Days", IF([Workdays to Go-Live Target]@row >= 61, "60+ Days", "TBD")))))))

Andrée Starå

@Paul Newcome Good Catch! Thanks!

@Jennifer Tillman Sorry about that!

Does it work now?

Rosa Kwok

Dear Sir

Each IF function works fine but when I combine them into one NEST IF eqn as below, there is #UNPARSEABLE error.

Could you help to check what is wrong?

=IF(OR([PI Risk]@row = "High", [PQA Storage Risk]@row = "High"), "High", IF(AND([PI Risk]@row = "Low", [PQA Storage Risk]@row = "Low"), "Low", IF(AND([PI Risk]@row = "Low", [PQA Storage Risk]@row = ""), "Low", IF(AND([PI Risk]@row = "", [PQA Storage Risk]@row = ""), "Low", IF(AND([PI Risk]@row = "", [PQA Storage Risk]@row = ""), "", “Medium”)))))