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.


Matt Silva
edited 12/09/19 in Archived 2015 Posts

I have developed a dashboard sheet that contains data from 3 different  source sheets.  Unfortunately, it requires me to manually input the data.  Is there a way to use a formluain  one sheet that relies on data from another sheet.  I know this can be done in excel, but can't seem to find a solution with Smartsheet.


I know I could setup the formulas on the data source sheets and then just link them.  However, this is a clunky solution.  Plus, we do quite a bit of filtering on those sheets and the formula cells distort the data after the filter is applied.



This discussion has been closed.