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