How to build a row amortization formula

Smartsheet Novice

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

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.