How to build a row amortization formula


I have the following fields in smartsheet:

Value: 10,000

Remaining Periods: 20

Amortization per Period: 500

I am able to create a row amortization in excel with a formula based on the "Column name", but unsure how to do this in smartsheet since I can't reference column name. Is there a way I can easily recreate this? (see screenshot below)


  • Mark.poole
    Mark.poole ✭✭✭✭✭

    If you're referencing the entire column do [Column name]:[Column Name].

    If your formula is looking just at the row its on then [Column Name]@row.

    If you found this comment helpful. Please respond with the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, and accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!