Join function

Hi Team,

I wish to use the join function to bring the two highlighted values together separated by "/"

So, the results should come out as 11/11

Can you suggest as my formulae is throwing error.



Answers

  • Porzel Hans
    Porzel Hans ✭✭✭✭

    Hi Gaurav,

    My suggestion is shown here at the picture / screen shot.

    Formula would be at this case: =JOIN(Month@row:Day@row, Seperator@row)

    Hope I could help you!

    Best regards

    Hans P. ... from Germany


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!