Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Pulling the Value from Single Select Drop Down

Solved
Jump to Solution
2392 2
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!