IF or IF/AND Statement Help

I have been trying to figure this out for days and I feel like I have been SO close but can't get anything to return...just the infamous "#UNPARSEABLE".

I want the formula to return the results of two combined cells based on what the response in another cell are. If the information in [GD / Ortho] equals "GD", I want the result in the [Clinic/Dongle Name Formula Trial] column to be what is in the [Office Number] AND [Clinic Name] columns. If not, I want it to be what is in the [Provider Employee ID] AND [Ortho Provider Name] columns. I've tried IF as well as IF/AND formulas and I'm just not getting anywhere. I'm unable to attach images or files which I know is going to make this even more difficult to assist with. :(

Best Answer


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Try something like this:

    =IF([GD / Ortho]@row = "GD", [Office Number]@row + " " + [Clinic Name]@row, [Provider Employee ID]@row + " " + [Ortho Provider Name]@row)

    If that does not work, are you able to make a copy of the sheet and replace the confidential data with mock data and provide a screenshot of that for reference?

  • kelly.strom
    kelly.strom ✭✭✭

    This worked BEAUTIFULLY! I'm VERY new to Smartsheet and have been able to figure out most things based on the Community Support...but this just was beyond me! The good news...I was SO close with some of my attempts. I was missing the use of the plus sign vs the ampersand. Thank you so very much, Paul!!!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help. 👍️

    Yes. One of the more prevalent differences between Excel and Smartsheet formulas is in Smartsheet you "add" things together. "This plus that" instead of "this and that".

  • kelly.strom
    kelly.strom ✭✭✭

    Any other tips/tricks like that up your sleeve that would be useful to a beginner? :D

  • Genevieve P.
    Genevieve P. Employee Admin

    I've been tagged 👀 Oh hello!

    Yes, I full agree with all of Paul's suggestions above!

    We recently cleaned up the Welcome to the Community area to help you get started here. Please feel free to leave any comments or feedback on those posts.

    I would say those are the best resources for when you're actively working in Smartsheet building formulas. However if you can set aside some time to research and learn, the Smartsheet University courses are great!

    There are also some free Webinars that walk through formulas:

    Finally, I would suggest reading through the Formula FAQ article, here. Some of the top stumbling blocks are explained here... such as checking if your numerical values are seen as text (left side of the cell) or numbers (right side of the cell), and if you're using the TODAY() function, check that the sheet is "refreshed" or opened each day to recognize today's date.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!