# How to multiply ???

edited 01/15/22

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)

Tags:

• ✭✭✭✭✭✭

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• 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

• I found the solution, thank you

• ✭✭✭✭✭✭

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!