Simple row multiplication formula

Hey all. Looking to have a row for an MSRP where the row shows the suggest 15% markup on a row.

For example say row named COST is $100 and I want a markup of 15%, I want to create a formula to multiple COST row * 15%

I am multiplying 1 row by a fixed number. I am not multiplying two rows together.

What's the correct way to achieve this?

Find more posts tagged with

Formulas

Accepted answers

Neil Watson

Option 1: a simple formula

Option 2: an additional markup column

Option 3: sheet summary

All comments

Neil Watson

This way works. It does depend on what you are trying to achieve and the future plans.

For example, can the mark up change in the future? If you place the 15% in the formula then you have to go back and change it which can be tiresome if you have a lot of rows.

An option is to make a sheet summary field called markup with the 15%. And reference in the formula cost@row*markup#

Mycelus

https://community.smartsheet.com/discussion/comment/309453#Comment_309453

I guess I don't quite understand what you're suggesting

Neil Watson

Option 1: a simple formula

Option 2: an additional markup column

Option 3: sheet summary

Mycelus

I have a column named Price Bought

I did

=Price Bought@row * 1.15

but I got #UNPARSEABLE

Mycelus

I was able to do =[Price Bought]@row * 1.15 and that did the trick, thank you!

Neil Watson

Yes, you need to use [ ] whenever the column name has a space

Mycelus

Excellent info, thank you!

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.