Formula for Text

Options

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 ✭✭✭✭✭✭

04/18/19
Options
=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

Is there a way to see if my sheet is being referenced?
I have a sheet I would like to delete but I want to make sure it is not being referenced or being pulled into a dashboard. Can I do that?
How to have separate data table for a new version of the form?
Hi All, I created a copy of the form I used so far, to ask a bit different questions and to collect the data in a bit different way. After the pilot stage I want to decide which version 1st or 2nd of the form will be used as the final version. But I see that the data punched into this 2nd version of the form are collected…
TO DO LIST follow up via general meeting list
Hallo en good afternoon , All the meetings within TVP we list them up into a Smarthseet. Grid is named by meeting follow up…. Into the sheet we have created different intern customers. This makes that we have a report per intern customer , so you can work easily in meetings with a structure. As you see below Build up in…

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