Help

Re: Pulling the Value from Single Select Drop Down

Solved
Jump to Solution
810 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Tucker_McKenzie
5 - Automation Enthusiast
5 - Automation Enthusiast

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).

1 Solution

Accepted Solutions
AlliAlosa
10 - Mercury
10 - Mercury

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

For example:

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

Hope that helps!

See Solution in Thread

2 Replies 2
AlliAlosa
10 - Mercury
10 - Mercury

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

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!