I am using the formula below:
and getting #UNPARSEABLE error. I noticed the formula below works if I just use
but I need to account for the third item and I am getting #UNPARSEABLE error. I appreciate any help on this
Assuming your formula is directly copy-pasted, you are missing a close-quote on the third argument in the OR function. This would definitely cause the #UNPARSEABLE error. Resolution should be to simply add your missing quotation mark.
You have 2 issues with your quotes.
Issue 1: You forgot to close your quotes after the third "specific text".
Issue 2: Notice how the opening quote before the third "specific text" is slanted to show "open" whereas the other quotes in your formula are not? Those are called "Smart quotes" and will break your formula every time. Remove that and retype it directly in the sheet.
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
Alex and Paul, thank you both very much! Formula is now working yesssssss!
Happy to help. 👍️
We have a spreadsheet with data that needs to be updated/validated twice a year. We wanted to use a workflow, but some owners/approvers of the data have 150 rows to their name. We don't want to flood their email with that many emails or have to go through 150 lines that way. We are working with the idea of sending an…
Hello- I am trying to remove the item names from the right side of the gaant chart. Is there a way to get rid of those and preferably add other column information instead? I see the settings pop up but there is no option to get rid of those labels. Thank you!
We would like to request the ability to add multiple conditions to a Conditional Formatting rule. For example: If Step="Backlog" and Flag=Yes, mark row orange.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.