Help

Creating a formula that multiplies values from a linked table to another field

Topic Labels: Formulas
Solved
Jump to Solution
803 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Vito_Mancini
4 - Data Explorer
4 - Data Explorer

Hi all, I am sure this has all been asked before. I have a field that is linked to another table but I have ‘Allow linking to multiple records’. When I create a formula that multiples this field to another, it will work when there is only one record selected in the linked field but returns a ‘1’ when it tries to multiply to both.

Ideally, the numbers in the linked field would be added together to give a total, then the formula could multiply that number with the other field to give me a total. Is that workable?

1 Solution

Accepted Solutions
Vito_Mancini
4 - Data Explorer
4 - Data Explorer

Thanks for those who have started looking into this. What I did was the following:

(SUM({Size (Ha)})*{App Rate (L/Ha)}

It seems to have worked! Don’t worry, I’ll have plenty of more questions.

Regards,
Vito

See Solution in Thread

2 Replies 2
Vito_Mancini
4 - Data Explorer
4 - Data Explorer

Thanks for those who have started looking into this. What I did was the following:

(SUM({Size (Ha)})*{App Rate (L/Ha)}

It seems to have worked! Don’t worry, I’ll have plenty of more questions.

Regards,
Vito

Welcome to the Airtable community!

Thank you for posting your solution.

Would you mind also letting us know the field type of your {Size (Ha)} field? Is it your linked record field, a lookup field, or something else? Field types play an important part in figuring out issues with formulas.

Normally I would expect the formula you posted to be in a rollup field.