# Nested IF giving me an Unparseable error

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!

«1

• Hi Jennifer,

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

-Zack Mitchell

• 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")))))))

• ✭✭✭✭✭✭

Hi Jennifer,

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | 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, Andrée. Sadly, it did not work but I appreciate the help!

• ✭✭✭✭✭✭

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)

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭

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")))))))

• ✭✭✭✭✭✭

@Paul Newcome Good catched! 😉

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | 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! Sadly, this did not work. I think I may be too ambitious!

• ✭✭✭✭✭✭

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)

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭

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

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

• ✭✭✭✭✭✭

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭

@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")))))))

• ✭✭✭✭✭✭

@Paul Newcome Good Catch! Thanks!

Does it work now?

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• 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”)))))

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!