Assign a value to a label in a label column, the multiply by a number field

Hi Team

Its safe to say formulas are a little over my head. I’m looking to see if there is a possibility of assigning a value to a label field, then multiply that value by another number.

For example I would like to assign “Q.Cell” to a value of 0.3, then multiply by 20 to give me 6 in “System Size” (Formula column).

Note, there about a total of 7 labels

Screenshot 2022-10-06 203357


Try this:

SWITCH({Panels}, "Q.Cell 330", 0.3, "Trina 400", 0.4, ...., 999999) * {Number of Panels} 

Jim - The Monday Man
:magic_wand: Column Magic :sparkles:- the magical columns toolbox app