Linking Date
Hi
I have a Master Smart Sheet and a number of other smartsheets linked to the Master sheet.
I have trouble linking the end dates to this Master Sheet but no trouble with the start dates.
I need to link the end date as that's the one that can keep varying and it is a lot of work to updating the new end date on the master sheet. Is there any solution for this problem ?
Thank you
Comments
-
Hi,
How are you trying to link them?
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:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Please find attached Images.
Link from cell in other sheet option has been disabled.
Second image is screenshot of the setting of the dates.
-
Ok.
You can't link to a Start, or End date in a sheet with dependencies enabled.
You would either need to disable the dependencies or have another column to link a date from another sheet.
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
You can't link the end date, but you should be able to link the duration, which should make the end dates line up.