Can you Log a Cell In time?

Jay T

Within my project sheet I have formulas set up to show me the present of Target duration vs actual completion date. The parentage in cell will change as we close out projects. Is there a way to track/Log this cell as it changes so that I can create a line graph to see our patterns over time?

Andrée Starå

Hi @Jay T

I hope you're well and safe!

You can use a Workflow with the Copy row Action to copy the row when it changes to a so-called helper sheet that you then use to create what you need.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!