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