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

Shaine Greenwood

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