How to multiply ???

Hi, I am new to smartsheet and I have a rather basic question.

I am working on a sales pipeline and I want to have an estimated sales based on the probability.

The way I am setting this up is:

1st Column: Product Price

2nd Column: Customer Stage (Lead, Contacted, Negotiating, etc...)

3rd Column: Probability ( Calculating using IF function: if lead = 10%, contacted = 20%, etc...)

and I want to have the 4th column that return estimated sales value based on the Product price and Probability (as the result of the IF function)

However, when I enter: =1st Column * 3rd Column , it does not work. It says Invalid Operation (as picture)

What should I do?

Thank you

(Sorry the Sheet was made for staff in Vietnamese but I guess you can tell my setup as described)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!