Hi, Smartsheet friends. I am new to Smartsheet and am still trying to find my way around. Is it possible to calculate a formula on one sheet that references data on a separate sheet, like you can in Excel?
I have a master sheet that includes all my data. I tried to summarize the data using various calculations at the bottom of the sheet, but some of the numeric formulas are not working because they are located in date columns. There are a lot of date columns in the master sheet, so it isn't feasible to move the calculation to a different column.
Can someone please give me advice on how to resolve this issue? Any help is much appreciated.