Profit formula
Sorry for the basic question. I need a row that calculates profit. I have a row titled COGS and a row titled Sold Price and a row titled Profit/Loss. What and how do I add a formula to the Profit/loss row that would calculate that for me? I am SO GRATEFUL for any help! Julie
Best Answer

In the row Profit/loss, enter a formula. Similar to Excel you can enter "=" and then select the cells and it will create the formula. After creating the formula, right click on it and "convert to column formula" if you want it to automatically enter in all rows.
=Sales@row  COGS@row
Answers

In the row Profit/loss, enter a formula. Similar to Excel you can enter "=" and then select the cells and it will create the formula. After creating the formula, right click on it and "convert to column formula" if you want it to automatically enter in all rows.
=Sales@row  COGS@row

Thank you so much dojones!

feeling like an idiot..what am I missing here?

The formula is based on the name of the column. Sales doesn't exist in the sheet. Your formula should be [Sold Price]@row  COGS@row
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 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
 284 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!