Collecting data over time

Adam Taylor
edited 12/09/19 in Smartsheet Basics

I have a portfolio of 20 projects, the project manager of each currently provides me with a weekly estimate of their total capital requirement for the year via an automated update request in smartsheet.

At the moment, this gives me a weekly static snapshot, but I'd like an automated way of seeing changes over time.

Is there a way that each week's entry can be recorded sequentially to the last, rather than over-writing it - i.e. so I can see how each project's capital requirement changes over-time?