Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Rollup using a group of results from linked table

Topic Labels: Formulas
974 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Simon_Horwood1
4 - Data Explorer
4 - Data Explorer

Hi guys, I am having trouble with an ROLLUP function hoping for some help.

See LOOM video attached

How on earth can I ROLLUP using a GROUP of results from a list.

Essentially this is my workflow plan.

APP: to create a Nutritional Label from data sources in the airtable data.

Workflow:

  1. Create new recipe

  2. Assign (link) ingredients to the recipe based on linked fields.

  3. Group the ingredeients linked to that recipe.

  4. Use formulas to create nutiriontal values based on the values from the linked ingredients.

Where I am getting stuck is grabbing the values from a group of ingredients, especially in a ROLLUP.

Screen Shot 2021-01-18 at 9.22.59 pm

1 Reply 1
Hossam_Khedr
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Simon,

Try loosing the condition. I tested a similar but much simpler base without the condition and used ARRAYJOIN(values) in the aggregation formula, it worked perfectly well.