Sum but stop off date

hello smarties... i need to create a formula so that the interest due stops on a payment date

Currently i have the following formula in the Interest Due column...

=SUM([Future Charges]@row + [Amount placed]@row * [Interest Percent]@row * [# of Months]@row) / 12

I need to add that it needs to stop on the Payment Date

thank you


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!