Cross Sheet References


We have a data entry sheet where data is entered via forms and an overview sheet, that is an overview sheet with cross sheet references. Using sumif formulas, however this only works when you open and save the overview sheet, you can't get live data unless you open and save the overview. Any workaround to this?


J Tech

If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!