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.

Assigning Numeric Value to Text

871 1
cancel
Showing results for 
Search instead for 
Did you mean: 
MarissaP
4 - Data Explorer
4 - Data Explorer

Hi! Im trying to assign a currency value from a single select field text and am having trouble. I've tried using the IF function and I can get it to look how I want, but the field is not a number field and so will not give me a sum. For example my single select has 2 options "Regular" or "Reserved" . If I select "Regular" I want my formula field to automatically assign a monetary value of $100. And then I want to see the sum of all of those. How can I do this?

Thank you!

1 Reply 1
kuovonne
18 - Pluto
18 - Pluto

Are you putting your 100 in quotes! If so, remove the quotes. If you are adding the currency symbol "$" in your formula, take it out and use the formatting options for the formula field to insert the currency symbol.