Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
"Gantt Chart" and "Sort by Date" do not work as expected
I am trying to create a consolidated sheet for past projects. I have inserted each project's Start-date and End-date as links from other cells. However the gantt chart is not correct, please see the first attached screen; i.e. missing project A and project E. Also if I try to sort by start date, the sorting result is incorrect, please see the second attached screen.
My purpose of creating a consolidated sheet is for overviewing the timeline of multiple projects. Any advices? Thanks in advance.
Comments
-
Updated:
Attached the screen is my desired result. I have duplicated the original sheet to a new one which contained values only. Seems that there are some uncertainties when a sheet contains links from cells in other sheets.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives