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
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?








  • Benjamin Walker

    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

  • 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.

This discussion has been closed.