Summing $ from Multi-select dropdown that includes text
I am running into a problem that I have not been able to find in the community.
I have a multi-select dropdown column that includes text and $ values, e.g. A - $25.00, B - $30.00, etc... I would like to take the selection from the column and sum the $ values. I would then multiply that by the Qty, =( )* Qty@row.
I am able to calculate when one item is selected using =VALUE(SUBSTITUTE([Sample Products]@row, LEFT([Sample Products]@row,FIND("-", [Sample Products]@row)+1),"")) * Qty@row. However, when I have multiple selections it generates an INVALID VALUE error.
**** The highlighted columns are me thinking that if I can isolate the Sample Product selection I could then sum from those. However, I am not using them in this formula.****
Help Article Resources
Check out the Formula Handbook template!