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.

Find more posts tagged with

Formulas

Accepted answers

Mark Cronk

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

All comments

Mark Cronk

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

Shawna Al-Mashouq

Ah! Yes, thank you so much!

Mark Cronk

Hi Shawna, Glad you found a solution. Thank you for contributing to the Community. Happy to help anytime.

Mark

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.