Simple row multiplication formula

Mycelus

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?

Neil Watson

Option 1: a simple formula

Option 2: an additional markup column

Option 3: sheet summary

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!