Concatenate returning 'unparseable' - doesn't like the " (" or the ") " in the formula


I really hope someone can help me with this please...I'm sure there is just a tiny tweak I need to make, but I can't figure it out. I've tried this formula in a helper column but it doesn't like the " (" or the ") " in the formula. It only seems to be able to cope with + "" or + "-".

This is the formula that's coming back as unparseable.

It's really simple. Here's the example of what I want to achieve as a result...

UK - Project Name - London (John Smith)

When I remove the brackets around the name in the formula, it works, but I can't get the formula to work when putting a bracket around the cell name.

I think I'm missing something really obvious.

Thanks in advance for any help.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!