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

Where can we find the sheets a column is supplying dynamic dropdown information to?
Hello everyone! I need to delete a column that is used in dynamic dropdowns in other sheets. How can I see a list of all the sheets that will be affected by the change? I'm looking for a way to find every sheet and column that uses the original column for their dropdowns. Thank you!
Issues with Notification color/branding
Hi all - just thought I would float this here first to see if anyone has had similar experience (and any fixes), before sending a ticket through to support. Have a basic automation notification set up with a company logo and task bar color in place. All has been working great but today it won't include the company logo or…
How can I set up a Notification if my Primary Column is not a contact list, but the Requestors email?
Hi, Is there a way that I can set up a Notification Automation that goes to the email/requestor is their email is the Primary Column? Currently I have the Primary column as "Created By", and the requestors input their email address. But, if I try to set up a Notification automation using the Template or even from Scratch.…