i.e.

I want to have a type of gannt chart or graph in my spread sheet which automatically updates itself when an enduser clicks a tick box to approve a doc.

Once the doc is approved. ideally I would like the spread sheet to be able to update the graph for me to show when a certain doc was approved against a predicted/expected date.

so I could see if it happened on time, late, early etc. like a gannt chart.

this chart doesn't have to be an actual chart, it could be just conditionally formatting cells to colour etc.


Basically I have an idea, but first I need to know how to tell the tick box (when ticked) to display the current date in lets say.. a1.