Possible to multiply all cells in a column by a value in a specified cell?

Rishi Montesdeoca · 04/28/23

Hi,

Newbie here so this might be a silly question. I have a sheet with product numbers and prices. Recently we had a price increase across all of our products. I was hoping to be able to take all the values in my price column and multiply them by 6% (the price increase). I have the 6% hanging out in a specified cell. Is it possible to multiply all the cells in my price column by the 6% cell I have?

Deric · 04/29/23

I would create a helper column, then copy and paste. I don't know if there is a better way.

=[CurrentPrice]@row * (1 + [Percent Column]1)

Andrée Starå · 04/29/23

Hi @Rishi Montesdeoca

I hope you're well and safe!

If I understand you correctly, you could add the value to a Sheet Summary Field and reference it in a formula to get the increased price.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Rishi Montesdeoca · 05/01/23

https://community.smartsheet.com/discussion/comment/373776#Comment_373776

Thank you! I think this could work well

Possible to multiply all cells in a column by a value in a specified cell?

Answers

Help Article Resources

Categories