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
 Smartsheet Customer Resources
 62.1K Get Help
 352 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!