I am checking a cell to see if it contains a name, If true, I want to return another cell value, if false blank.
=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!
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
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!
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello, when I modify a start date on a task I lose the predecessor links. Is there a method to modify task start dates without losing the links? THANKS.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.