hi,
i have a array in one cell (A1) , like this:
dog,cat,fish
and i have a table of prices, like this:
data - cost
dog - 1
cat - 2
fish - 3
i want to get a formula that sum all the array, 1+2+3=6.
i traied to put this, its work in Excel, but dont wotk in Coda…
=SUMPRODUCT(ISNUMBER(FIND(table.data,A1))*(table.cost))
help!! tY!
on the canvas type
=[NameofTable].[cost].sum()
i have many cells like this. i want a formula that for any cell will return the sum…
dog,cat = 3
fish =3…
Ah, that’s a bit more complicated, but doable.
Look in my doc and make a copy so you can check out the formula.
ty my frind, i cant see the formula in view only…
can u write it?
ty!!
You need to copy this doc and then you can play with it (there are three little dots upper left - one of the options is copy).
Split(thisRow.Name,",").FormulaMap(Lookup(Animals,Animals.Name,trim(CurrentValue)).price).sum()
ty, work execellent!!!
i tried to copy. but in offline mode, dont know how to get into online… (first day with Coda=])
I just added another table with a lookup - which I like better - and the formula is very simple. The only drawback is that you can’t repeat the same choice in the same row, so ‘cat cat’ is not possible, but you’ll get a list of all available items and you can’t make typos.
The selection column is a lookup column.
This is exactly what I was looking for. i dont want a option to repeat the same choice. TY!!
