#UNPARSEABLE Error
I've tried this formula in Excel to ensure I have the correct syntax and that it actually works...which is does. But when I recreate the formula in Smartsheet and reference the appropriate Smartsheet, I receive the #UNPARSEABLE error.
=SUMIFS({Sheet - Project Intake with Form Range 4}, {Sheet - Project Intake with Form Range 3,"Daily Checks",{Sheet - Project Intake with Form Range 2},"Receive From Canon"})
I've tried selecting both a range of cells and the entire column, both of which result in the same error.
Thanks in advance for any help or leads provided!
Best Answer
-
Hi @Ngoc L.
A curly bracket is inadvertently out of place.
Try this
=SUMIFS({Sheet - Project Intake with Form Range 4}, {Sheet - Project Intake with Form Range 3},"Daily Checks",{Sheet - Project Intake with Form Range 2},"Receive From Canon")
Answers
-
Hi @Ngoc L.
A curly bracket is inadvertently out of place.
Try this
=SUMIFS({Sheet - Project Intake with Form Range 4}, {Sheet - Project Intake with Form Range 3},"Daily Checks",{Sheet - Project Intake with Form Range 2},"Receive From Canon")
-
That worked!!! Thank you so much Kelly! I really appreciate you quick response and help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!