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.

Issues linking cells

Peter Vennel
Peter Vennel ✭
edited 12/09/19 in Archived 2016 Posts

I have created a dashboard linking cells to cells in other sheets. It has been working great.

 

However, I am now running into issues when linking new cells:

 

  1. 1. The End date is not populated.
  2. 2. The %Complete in the dashboard does not roll up the the group.

 

If I try to link the <End Date> cell it says, "You cannot create a link in this cell because it's value is determined by a project dependency"

 

What am I missing?

 

 

 

Thanks,

Peter.

dashboard.jpg

· Share on FacebookShare on Twitter

Comments

  • Benjamin Walker
    Benjamin Walker Employee

    Are you cell linking into a Gantt enabled sheet with dependencies enabled?

     

    I do not see a column for duration, which is used to calculate the end date

    · Share on FacebookShare on Twitter
  • Peter Vennel
    Peter Vennel ✭

    Great! That was it. I was not linking the duration as it was not needed in the main dashboard. This solved both my issues. Talk of killing two birds with one stone... :)

     

    Thanks Benjamin for your quick response.

     

    p.s. This would be a great thing to add to FAQ/Troubleshooting.  That way, othes can benefit from it.

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

Categories