Creating formulars and automating payment terms with regard to cash flow amount and month of payment

I need to create a Smartsheet that allows me to manage different payment terms for specific monthly payments. This sheet should enable me to manually record payments in a designated month column and automatically capture the payment terms in another column, reflecting the month the payment will be made and the exact amount. Can someone helps with formulating such table and the relevant formulars.
Answers
-
Hi @Bokabasa,
looks like you need a simple solution to be created with forms & simple formulas.
but it's not possible to build such solution on such description and you would need to provide the requirements.
Experienced IT PM and the Real Smartsheet Enthusiast.
Is there anything else we can help you with? - book your time.
MASA Consult - Your Aligned Smartsheet Gold Partner
Find us on LinkedIn & Check our Smartsheet Solutions!
Tag my name: @kowal if you want me to respond :)
Help Article Resources
Categories
Check out the Formula Handbook template!