Formulas don't calculate when cell containing formula is linked
Melissa Campbell
✭✭✭
I have a sheet that totals the row values when a row is added from a form. It worked well until the cell containing the formula was linked using vlookup to a separate sheet that is the source of a dashboard. Now it will not calculate and the sheet that references the cell will not be displayed in the fo
Tags:
Comments
-
Hi Melissa,
Try opening the sheet which contains the formula and saving that sheet.
If that doesn't work, double-check your cross-sheet reference and make sure that it's still referencing the correct range of cells.
More information on cross-sheet references for formulas can be found in the help center: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!