Nested IF giving me an Unparseable error
Answers
-
Try redoing your quotes around the last "Medium". You will notice that all other quotes in your formula and the quotes in this comment are straight up and down whereas the quotes around your last "Medium" are angled to show open and close. These are called "smart quotes" and will cause an #UNPARSEABLE error.
I also notice that you have duplicated your criteria and given two different outputs. You may want to revisit that section as well. It will not cause an error, but it could cause unexpected results.
..................... IF(AND([PI Risk]@row = "", [PQA Storage Risk]@row = ""), "Low", IF(AND([PI Risk]@row = "", [PQA Storage Risk]@row = ""), "",..........................................
-
Thank you everyone but I won't need assistance with this anymore! We moved out of Smartsheet last week to Google Sheets. Smartsheet deactivated our form used to populate the sheet (got too big for Smartsheet to handle). We didn't even get a warning from Smartsheet this was happening and it caused a huge disruption to our business (healthcare) as it was used for emergency response plans for COVID-19. You really should get some advance notice if your form is deactivated.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!