Depreciation Cost Help

mdonaldson ✭✭
edited 12/08/23 in Formulas and Functions

Wanted to use the template listed to create a new sheet and see if it would work that way, but it isn't available any longer..

Essentially, I'd like to be able to find the depreciation cost year over year of assets currently being tracked in a sheet. We display the cost price paid on purchase, and the date of purchase, but nothing beyond that.

Is there a formula I could use to display the depreciation cost in another column? What would that look like? I'd prefer not changing a lot of the sheet, as it works pretty well the way it's currently set up now.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!