Link
I'm trying to create a link on the Actual End Date column and this is the error I'm seeing:
so the goal is that if my colleagues update their actual end date on their project sheet, it will auto update to the Masterfile; but because I have a "Days" column to track how long (Actual Start Date vs Actual End Date), it's not allowing me to link that column from Master sheet to hers. Any work around?
Answers
-
Have you thought about using a 'helper' column?. You could create a Helper Column in your colleagues' project sheets where they manually enter the Actual End Date, use a formula to grab this date and link this Helper Column to your Master Sheet. Since this column isn't determined by dependencies, you should be able to link it without issues.
In your Master Sheet, create a formula in a new column to calculate the difference between the Actual Start Date and the Helper Column's date.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives