Receiving #UNPARSEABLE error on simple If formula
Comments
-
=IF([Building Manager]1="Ron Hendrickson", [Contracted Hours]1)
It is assumed if the IF Statement isn't Ron Hendrickson, then the field will be blank. You could also code it with a , "" at the end like this.
=IF([Building Manager]1="Ron Hendrickson", [Contracted Hours]1, "")
You had the right idea, but you were missing the = sign after [Building Manger]1 and you were only searching for Ron instead of the full name. Not sure if that was intentional or not.
Hope that helps!
-
Hi Mike
That worked. Thanks for your help.
I thought I had tried the = in one of my attempts.
The "Ron" was just one of the thousand variations I tried...ha ha.
I had also tried to put a "" in the false argument.
Again, thanks heaps.
-
Glad I could help out!
In regard to errors, this link is very helpful in understanding what they are: https://help.smartsheet.com/articles/2476176-formula-error-messages
And I keep this link bookmarked when trying to grasp the syntax and structure of different formulas: https://help.smartsheet.com/functions
-
I’m in a similar spot, but even with the suggestions made, I am still getting the #UNPARSEABLE error. Any ideas? Thanks
-
Hi @HSL
Your quotes look angled or curved - Smartsheet will return an error if the quotes used are curved instead of straight up and down, like this: "
Try re-typing in the quotes directly in Smartsheet (versus copying/pasting from somewhere else), that should get rid of the error!
Cheers,
Genevieve