Calculating a fee based on QTY delivered and total fee outstanding

I am looking to calculate a fee amount based on total fee and qty delivered. For example, if I have two items on a PO, but only one delivers, the Fee to be Paid would only be half of the total. If all items deliver, the "Total Admin Fee" would copy over to "Admin Fee to be Paid".

In the snip below, for the highlighted row, the "Admin Fee to be Paid" should be $75 (total admin fee/4=75. One item of 4 was delivered). If 2 of 3 had delivered, $150, 3 of the 4 it would be $225, etc.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!