Linking upcoming dates from sub sheet to the master sheet

Justin Lee

My company has a master sheet connected to all the different project sheets. Is it possible to have the next due dates listed in the project sheets automated to update on the master sheet? Currently, we're just doing this manually and it is a pain for us to constantly look at the sheets.

Andrée Starå

Hi Justin,

Yes, there are. You could probably use cell-linking or cross-sheet formulas to automate it.

Would that work?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting​