Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Just discovered JOIN formaula - very helpful!
However, I can't seem to get it to join THREE coloumns together.
I'm using this formaula for joining two which is working perfect:
=JOIN([Quantity (m3)]1:[Time required]1, "-")
However, when I try and add in another (so a third coloumn) it errors.
=JOIN([Quantity (m3)]1:[Time required]1:[Boral O/N]1, "-") I get #UNPARSEABLE
Can it not deal with a third???? If not, are there any other solutions?