Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Apr 08, 2022 03:06 PM
Hello,
I’m trying to see if it’s possible to list the quantity of each item from a lookup field.
For example, I’m trying to create a field that will list how many tickets per priority (I can obviously do this through a chart but I’m trying to get the data here for page designer)
and how many tickets are plumbing related.
So i’m trying to get a field that display something like this:
Same for priority:
Apr 08, 2022 08:41 PM
You cannot do this directly in the lookup. You can create a conditional rollup for each select option that counts the number of times that particular option appears. Set the rollup condition to include only records where the select is a particular choice. Use the rollup formula COUNTALL(values)
Then you could have a different formula field that combines the values of those rollup fields.
CONCATENATE(
"- " & {rollup for urgent} & " urgent ticket(s)\n",
"- " & {rollup for high priority} & " high priority ticket(s)\n",
"- " & {rollup for medium} & " medium ticket(s)\n",
"- " & {rollup for low} & " low ticket(s)"
)