Criteria is Parsable when using a number but unparsable when using text
Best Answer
-
See how your quotes around "Complete" are slanted but the ones in this comment are straight up and down? The slanted ones are called "Smart Quotes" which (ironically enough) are not recognized as valid characters in a Smartsheet formula.
Try retyping the quotes directly in the sheet or in a text editor such as Notepad (not Word).
Answers
-
Both of those formulas resolve for me. So maybe a bug. Try a new sheet.
-
Started from scratch and same result
-
Hi @Billymacdo
Can you share a screenshot of the sheet & the range of the reference data in {Brand To-Dos Range Status}?
Thanks,
Sam
—
Want to chat about a Smartsheet problem you're facing?
Grab time on my calendar here:
https://calendly.com/sam-samharwart/30min -
See how your quotes around "Complete" are slanted but the ones in this comment are straight up and down? The slanted ones are called "Smart Quotes" which (ironically enough) are not recognized as valid characters in a Smartsheet formula.
Try retyping the quotes directly in the sheet or in a text editor such as Notepad (not Word).
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!