How to multiply ???

Coach Duy Nguyen

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)

Andrée Starå

Hi @Coach Duy Nguyen

I hope you're well and safe!

It seems that the percentage is read as text.

How are you getting the percentage?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Coach Duy Nguyen

Hi @Andrée Starå ,

Thank you for responding to my questions.

The percentages are calculated using IF formula (as in picture). That's what I thought too. I was trying to find a formula that can convert that result to number values so that the Multiply can work. Do you know any work around?

Thank you

Coach Duy Nguyen

I found the solution, thank you

Andrée Starå

@Coach Duy Nguyen

Excellent!

Happy to help and glad that you figured it out!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!