Skip to main content

I would like to pull the value from a single select to use in a formula. For example, i have an opportunity that has a set value as well as a set of percentage of realization. I would like to multiply these two values to get a weighted value. See below for full example:


Project X has a $100,000 opportunity value, with a 70% chance of winning. The weighted value would be $70,000 ($100,000 x 0.70).

Try wrapping your single select field names in the VALUE() function 🙂


For example:


VALUE({Select Field 1}) * VALUE({Select Field 2})

Hope that helps!

Try wrapping your single select field names in the VALUE() function 🙂


For example:


VALUE({Select Field 1}) * VALUE({Select Field 2})

Hope that helps!


Thanks for this suggestion. I used the VALUE() formula, but it is just returning a 1 or a 0 (if of the single select fields are picked it provides a 1, if none selected it returns a 0).


However … I just checked the formatting and it was set to single integer … so 90% was rounding up … “fixing” the formatting “fixed” my problem, lol. Thanks for making me double check!

Terms & Conditions