Capital Asset Planning Annual Cost Chart?
Hello all-
I'm working on capital asset replacement planning and would like to be able to visualize what assets need to be replaced each year, represented by their cost. Ideally, a table would have a list of assets on the left, and years across the top, and would automatically populate a replacement cost in the year that it falls. Here is an Excel sheet that shows the idea...
Any ideas on how to accomplish this?
Thanks very much!
~Jeff in North Carolina
Answers
-
You can set up your smartsheet just like your excel sheet. Use row 2 as your column headings and put the inflation corrections into sheet summary fields so you can use those in your calculations.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!