Help

item-wise calculation/sum/multiplication of arrays of numbers

Topic Labels: Automations Formulas
703 1
cancel
Showing results for 
Search instead for 
Did you mean: 
atusr
8 - Airtable Astronomer
8 - Airtable Astronomer

is it there is a way, preferably with formula/s, to perform element-wise multiplication of two arrays of numbers?

For example, if I have two fields with arrays [1, 2, 3] and [4, 5, 6] respectively, can I write a formula that produces [4, 10, 18]?

_
I would also need a formula for:
Column1 (array 1): 2, 3, 5
Column2 (array 2): 5, 4, 1
Expected output: 7, 7, 6

is this achievable?

1 Reply 1

Could try using ARRAYSLICE() for it maybe?  You'd end up with a pretty hardcoded formula field though