Unable to use hyperlink/link from cell in other sheet
Hello,
For some reason, I am unable to hyperlink or use the link from cell in other sheet for my finish dates for tasks in my various Smartsheets. The option is greyed out for this particular column, but I can use those functions for the start date of my tasks.
I am not sure what to do.
Answers
-
If you have dependencies enabled in the sheet (typical for a project plan), then the Finish date is calculated automatically based on the duration and other dependencies. So, since this is a calculated column, the sheet does not allow you to select a specific finish date as a cell link from another sheet.
If you need this ability you'll have to disable Dependencies (found under Project Settings). The downside is that you lose the automatic cascade of dates.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives