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
- 63.3K Get Help
- 392 Global Discussions
- 213 Industry Talk
- 447 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives