Messages

1

Feature Requests / Re: Possible to add three columns?

« on: January 18, 2020, 02:23:03 pm »

Thanks for helping us get back into the forum account.  Not sure what happened there. 

On the first issue.  (copying formulas) I am familiar with how to normally copy and paste formulas between cells.  However, for some reason whenever I attempted to do it in the MyCostPro workbook it wouldn't allow me to.  I tried both right clicking and clicking copy on a cell. but when I went to paste the option is greyed out.  Also, I attempted to do it via the other method where you input the formula in the first cell, left-click the little square in the bottom right corner and drag downward to auto-populate the fields.

Second, I'd appreciate you helping with setting up the columns we need in order to achieve the goals we are working toward.  Thanks in advance for any assistance!

2

Feature Requests / Possible to add three columns?

« on: January 08, 2020, 08:55:34 am »

So I understand how to use a formula to calculate a percentage for a consignment sale.  However, is there a quicker way to do it rather than going to each item individually and typing it out for every item?

Also, would it be possible to get 3 additional columns added to the Sold Items tab?

The reason I am asking is we have a sales associate who earns a commission on every item sold. This commission is based on the sale price minus any shipping as we offer free shipping.  So as I see it, we would need three additional columns.  First we would need a column in which shows the sale price minus shipping costs.  Then we'd need a column where the commission percentage could be entered, and finally a column that shows the actual dollar amount of any commission owed. 

Additionally, it'd be nice if this commission could also be deducted for the ROI and Profit per item columns as well. 

Thanks in advance!