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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!