Use number from Single Select in calculation formula

Hello,

I am using a single select column with options as predefined numbers, 1 to 6 - representing hours (time sessions). I would then like to multiply the selected option with X (day rate) and output the result in a currency column (total cost).

I can’t get it to work. Is it possible? I would like to use a single select instead of a number field to input hours.

Hi @valushk - the single select output isn’t a number but a string, so you need to convert it to a number to use it in a math formula:

VALUE({Hours}) * 200

JB

2 Likes

Brilliant, thank you so much.