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.
