Is there a limit to the length of If/And Statements?
I have the following statement and it works for the bold section but when I add the italic section I receive an 'UNPARSABLE' error. Thoughts?
=IF(AND([From Calculator]2 = "<100", [From Calculator]4 = "<25"), [Column2]2, IF(AND([From Calculator]2 = "<100", [From Calculator]4 = "2650"), [Column3]2, IF(AND([From Calculator]2 = "<100", [From Calculator]4 = "51100"), [Column4]2,IF(AND([From Calculator]2 = "<100", [From Calculator]4 = ">100"), [Column5]2, IF(AND([From Calculator]2 = "101250", [From Calculator]4 = "<25"), [Column2]3, IF(AND([From Calculator]2 = "101250", [From Calculator]4 = "2650"), [Column3]3, IF(AND([From Calculator]2 = "101250", [From Calculator]4 = "51100"), [Column4]3, IF(AND([From Calculator]2 = "101250", [From Calculator]4 = ">100"), [Column5]3, IF(AND([From Calculator]2 = "251500", [From Calculator]4 = “<25”),[Column2]4, IF(AND([From Calculator]2 = "251500", [From Calculator]4 = “2650”),[Column3]4, IF(AND([From Calculator]2 = "251500", [From Calculator]4 = “51100”),[Column4]4, IF(AND([From Calculator]2 = "251500", [From Calculator]4 = “>100”), [Column5]4))))))))))))
I have 2 more statement sections I would like to add if possible.
IF(AND([From Calculator]2 = "5001,000", [From Calculator]4 = “<25”),[Column2]5, IF(AND([From Calculator]2 = "5001,000", [From Calculator]4 = “2650”),[Column3]5, IF(AND([From Calculator]2 = "5001,000", [From Calculator]4 = “51100”),[Column4]5, IF(AND([From Calculator]2 = "5001,000", [From Calculator]4 = “>100”),[Column5]5, IF(AND([From Calculator]2 = "1,0012,500", [From Calculator]4 = “<25”),[Column2]6, IF(AND([From Calculator]2 = "1,0012,500", [From Calculator]4 = “2650”),[Column3]6, IF(AND([From Calculator]2 = "1,0012,500", [From Calculator]4 = “51100”),[Column4]6, IF(AND([From Calculator]2 = "1,0012,500", [From Calculator]4 = “>100”),[Column5]6
Comments

Hi John,
If I remember correctly, the limit is 4000 characters.
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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 for the quick response but the character count above is 973 with spaces. I can't figure out what is wrong if anything.

Happy to help!
Could you maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)
Best,
Andrée
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.

I think I found the error. You had a few characters that were wrong.
“” and I replaced them with ".
Try this.
=IF(AND([From Calculator]2 = "<100", [From Calculator]4 = "<25"), [Column2]2, IF(AND([From Calculator]2 = "<100", [From Calculator]4 = "2650"), [Column3]2, IF(AND([From Calculator]2 = "<100", [From Calculator]4 = "51100"), [Column4]2,IF(AND([From Calculator]2 = "<100", [From Calculator]4 = ">100"), [Column5]2, IF(AND([From Calculator]2 = "101250", [From Calculator]4 = "<25"), [Column2]3, IF(AND([From Calculator]2 = "101250", [From Calculator]4 = "2650"), [Column3]3, IF(AND([From Calculator]2 = "101250", [From Calculator]4 = "51100"), [Column4]3, IF(AND([From Calculator]2 = "101250", [From Calculator]4 = ">100"), [Column5]3,IF(AND([From Calculator]2 = "251500", [From Calculator]4 = "<25"),[Column2]4, IF(AND([From Calculator]2 = "251500", [From Calculator]4 = "2650"),[Column3]4, IF(AND([From Calculator]2 = "251500", [From Calculator]4 = "51100"),[Column4]4, IF(AND([From Calculator]2 = "251500", [From Calculator]4 = ">100"), [Column5]4))))))))))))
I have 2 more statement sections I would like to add if possible.
IF(AND([From Calculator]2 = "5001,000", [From Calculator]4 = "<25"),[Column2]5, IF(AND([From Calculator]2 = "5001,000", [From Calculator]4 = "2650"),[Column3]5, IF(AND([From Calculator]2 = "5001,000", [From Calculator]4 = "51100"),[Column4]5, IF(AND([From Calculator]2 = "5001,000", [From Calculator]4 = ">100"),[Column5]5, IF(AND([From Calculator]2 = "1,0012,500", [From Calculator]4 = "<25"),[Column2]6, IF(AND([From Calculator]2 = "1,0012,500", [From Calculator]4 = "2650"),[Column3]6, IF(AND([From Calculator]2 = "1,0012,500", [From Calculator]4 = "51100"),[Column4]6, IF(AND([From Calculator]2 = "1,0012,500", [From Calculator]4 = ">100"),[Column5]6
Did it work?
Best,
Andrée
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.

Yes, the issue was that somewhere down the line Smart Quotes were inserted instead of straight quotes. Always compose your formulas in a basic text editor. Word and Google Docs adds a different quote to your formulas which break smartseheet.

This worked! Thank you very much. I was writing the statement in Word and didn't realize it was converting the style/angle of those double quotes.
Thanks!

Great!
I'm always happy to help!
Best,
Andrée
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.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!