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
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!