Multi-Text field and Total fields

Kind of a pain if you have a bunch of choices, but you can use a formula field and define a numeric variable for each option, then sum those variables.

So for example:

var text options = totext([CHANGE ORDER - LIST OF ITEMS NOT READY]);
var number optionA = if(contains($options, "TERMINATIONS"),2000,0);
var number optionB = if(contains($options, "EQUIPMENT SET UP"),2000,0);
var number optionC = if(contains($options, "GREENHOUSE"),3000,0);

and so on.  And then after you declare all of the variables, the formula is sum($optionA, $optionB, $optionC, ...)

------------------------------
Tyler Jablonski
------------------------------