Receiving #UNPARSEABLE error on simple If formula

andrew.taylor37161

I am checking a cell to see if it contains a name, If true, I want to return another cell value, if false blank.

Mike Wilday

=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! 

andrew.taylor37161

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.

Mike Wilday

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

HSL

I’m in a similar spot, but even with the suggestions made, I am still getting the #UNPARSEABLE error. Any ideas? Thanks

Genevieve P.

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