Group by only CERTAIN values

bweber · ‎Jul 19, 2023

Is there a way to group values by only a select number of groups?

I have a cell title "groups" where we dump in all records the various groups that we have in our base. i.e. Accelerator, Incubator, Advisory Board, Faculty, etc.. This means when I go to group one section, in this case the advisory board, the group gets split into multiple groups. Those with just "Advisory Board," those with "Advisory Board and Incubator" etc.

Is it possible to just group these by "Advisory Board" and "Faculty" and ignore all the other "Groups" that are present?

TIA!

Sho · ‎Jul 19, 2023

One idea is to group them by conditional branching in a formular field.

SWITCH({Group Name},
  "Advisory Board",{Group Name},
  "Incubator",{Group Name},
  ""
)

Group by this field.