Percentage of a number within a cell
In Excel, I can utilize the following formula to find the percentage of a number.
Input =H5*30.1%
Output $11,371.11
When H5=$37,777.78
However, in Smartsheet, the formula does not copy over and when the formula is manually entered in Smartsheet, it tells me that it is unparseable. Manually doing the calculation defeats the purpose of using Smartsheet. I suspect there is another formula that can do this same calculation. Please help.
Thanks.
Best Answer
-
Hi Shawna,
The formula in Smartsheets would refer to a column and row in place of H5. If you want the data in column [Quantity] multiplied by 30.1% the formula would be:
=Quantity@row * .301
If you column name has a space or special character it needs to be in square brackets [ ], e.g. [quantity sold]@row.
Help?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi Shawna,
The formula in Smartsheets would refer to a column and row in place of H5. If you want the data in column [Quantity] multiplied by 30.1% the formula would be:
=Quantity@row * .301
If you column name has a space or special character it needs to be in square brackets [ ], e.g. [quantity sold]@row.
Help?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Ah! Yes, thank you so much!
-
Hi Shawna, Glad you found a solution. Thank you for contributing to the Community. Happy to help anytime.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!