Linking upcoming dates from sub sheet to the master sheet

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.
Comments
-
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,Β andree@getdone.se)
Have a fantastic weekend!
Best,
AndrΓ©e StarΓ₯
Workflow Consultant @ Get Done Consultingβ
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.