nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Formula for Text

stephanie.blake67241

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"?

Find more posts tagged with

Comments

L_123

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

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

Sign in to join the conversation!

Quick Links

Trending discussions

Can't access issue submission
I have run into an interesting but small bug. When setting up an automation, the action 'change cell value' will allow you to select checkbox columns, but not checkbox columns that are the star or flag visual variant. Those can't be selected in the change value action. Now the real issue. I go to submit a bug report or…
Setting up the welcome and help screens.
Hello All, I am having difficulties uploading my information to the welcome and help screens. We are a Micro Soft 365 shop, using share point, and I am getting the error message that share point in refusing to connect. Whereas this appears to be a share point issue; I have reached out to our IT Department, and we cannot…
Workflow Causing an Infinite Loop
I have a workflow that is periodically causing an error that reads "This workflow triggered itself directly or through another workflow. Please modify the workflow so it doesn't cause an infinite loop."