How to - applying funds

is there a way to create a function that can apply funds across multiple cells if the funds received exceed an amount referenced in another cell?

example: funds received in the amount of $5,000, we have 2 outstanding invoices totaling $11,000.

invoice 1 = $3,000

invoice 2 = $8,000

can a formula "apply" the $5,000 to clear invoice 1 and apply the remainder to invoice 2?

hope this is clear and thank you for your help.



  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Are your invoices in separate rows or separate columns? Do you have some kind of unique identifier that will allow us to determine which invoice(s) the payment(s) are to be applied to?

  • Invoices are included in separate columns, we will never have more than 3 open invoices. No Unique identifier. i just may need to redo the format.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    I'm having a little trouble visualizing. Are you able to provide a screenshot with some mock data entered to show a few examples of what you have and what you are wanting to automate through formula(s)?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!