Percent Complete - by date

That's a reallly interesting feature.

My mind is spinning.

Inside Smartsheet will be clunky (I might start by copying rows, but I only want one or two columns, not the whole row).

Automating via Zapier might work ... add a new row to another sheet when the % complete changes for example.

Once on the other sheet, organize (either by formula or hierarchy) to get the data neat and then try to chart it - probably need something else outside Smartsheet ... but maybe not. 

Going on my to-do list.

Craig

Steve,

In the original sheet Identify the Rows that are your KPI Rows (Maybe a Checkbox Column) and check them.

Create a copy of your Project sheet No Data.

Create a named filter to identify the rows base on the check box.

On the given day each week, apply the filter and move to other sheet (This process does not copy formulae it copies results

Repeat every week.

You will then end up with a List of Snapshots.

Do as you want.

I am afraid the words Smartsheet and Automation are only just on speaking terms as yet.  We live in hope that this will improve.  In the meantime there are other tools out ther that can automate things in Smartsheet for you, like Zapier.