Formula for Text

stephanie.blake67241

stephanie.blake67241 ✭✭✭✭✭

04/18/19 edited 12/09/19 in Smartsheet Basics

Can I use a formula to capture text from the cells below it. For example, if I have "IT-1900" in row 2 and "IT-1901" in row 3, can my summary row show "IT-1900, IT-1901"?

0 ·

Comments

L_123 Community Champion

04/18/19

=join([Column2]3:[Column2]5,",")

if you want it to be based on criteria you need a join(collect())

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Making a new sheet after the most recent update
I used to be able to make a sheet in my own file (see img) using the Create button in the top right corner. Now I can't make a new sheet without creating a workspace around it. How do I make it not do that anymore? I just want to make a sheet for my own use and keep it in the file with all the others I'm currently using,…
Am I able to Change the Order of Items in the Legend on a Chart?
We would like to keep things consistent across the board for our PM's and business owners when it comes to the RAID Log. I have labeled them "1., 2., 3., 4." and it works in certain instances, but it's all over the place once we pull that info into charts on a dashboard. It now looks extra confusing. I am very new (3ish…
Can you schedule reminders in Board View?
I'm trying to transition myself to using Board and Table view over Card and Grid view, but haven't been able to figure out how to schedule reminders in Board view. Is there a spot on each task to create a reminder the way there is in Card view that I'm missing? Or is this feature just not available in Board view yet?

Help shape the future of Smartsheet.
Share your ideas and feature requests.