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)
Answers
-
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.
-
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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!