Let’s say I have drop list of 5 coloured balls and each colour has a value (for example green is 6 and red is 4)
Now lets say John has green and red, now the question is how to show score for John which would be 10.
Welcome to the community, @Nazmul_Bhuiyan
In SSDC, you can always write a formula for such computations.
Eg. =ARRAYFORMULA(SUM(VLOOKUP({SPLIT(B1,", ")},{"Red",1;"Green",2;"Blue",3},2)))
Also, sharing a sample workbook with reference implementation: Multi-Select field in formulas
1 Like
Thank you bro
I will try it and will let you know if it worked for me.
I tried with sum and vlookup, but it obviously didn’t work. What about with sumif and xlookup?
In Excel I could use filter function, is there something like filter in spreadsheet.com?
We do not yet support FILTER function.