Help

Grouping Rows by Matching Partial Text

Topic Labels: Formulas
Solved
Jump to Solution
191 2
cancel
Showing results for 
Search instead for 
Did you mean: 
brightvessel
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all,

Airtable Table Newbie, but feel in love.

I want to group rows by partial text in the field.

(CDPA) Campaign 1
(CDPA) Campaign 2
(CDPA) Campaign 3

I want to group all three above using the (CDPA).

I assume it would create a formula row to do this, but I do not know how to create the formula

Can someone help?

Thanks,

Judd

 

1 Solution

Accepted Solutions
brightvessel
5 - Automation Enthusiast
5 - Automation Enthusiast

I believe this would be the answer. I thought I needed a new column when it was just a duplicate current and filter in the column.

 

brightvessel_0-1706191451810.png

 

See Solution in Thread

2 Replies 2
brightvessel
5 - Automation Enthusiast
5 - Automation Enthusiast

brightvessel_0-1706183698356.png

Here is some more context. The column is a campaign name, and I want to group by a specific location, which titles differ except for the acronym, ex, CDPA.

 

 

 

brightvessel
5 - Automation Enthusiast
5 - Automation Enthusiast

I believe this would be the answer. I thought I needed a new column when it was just a duplicate current and filter in the column.

 

brightvessel_0-1706191451810.png