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

Options
Jan Lau
Jan Lau ✭✭
edited 05/17/17 in Archived 2017 Posts

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.

Screen Shot 2017-05-17 at 11.43.22 AM.png

Screen Shot 2017-05-17 at 11.44.58 AM.png

Screen Shot 2017-05-17 at 11.43.22 AM.png

Screen Shot 2017-05-17 at 11.44.58 AM.png

· Share on FacebookShare on Twitter

Comments

  • Jan Lau
    Jan Lau ✭✭

    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.  

     

    Screen Shot 2017-05-17 at 1.42.39 PM.png

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories