Skip to main content
Solved

Grouping Rows by Matching Partial Text

  • January 25, 2024
  • 2 replies
  • 31 views
B
Forum|alt.badge.img+3

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

 

Best answer by brightvessel

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.

 

 

2 replies

B
Forum|alt.badge.img+3
  • brightvessel
  • Author
  • Inspiring
  • January 25, 2024

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.

 

 

 

B
Forum|alt.badge.img+3
  • brightvessel
  • Author
  • Inspiring
  • Answer
  • January 25, 2024

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.

 

 

Terms & ConditionsAccessibility statement