Metric Sheet not pulling/updating data from main data sheet
Good Afternoon,
I recently completed a Data Shuttle import to my main sheet and it was completed with no errors, I then went to my main sheet and everything imported correctly, however when I went to my metrics sheet all the previous filled cells equaled zero. I have checked all formulas and they are correct. I have erased a formula and recreated it and it still does not calculate the value.
It is a "countifs" formula pulling data from three different columns, it has always updated in the past.
Thank you
Gail
Answers
-
Hi Gail Mootz ,
The formula in Metric sheet will get reference the main sheet. In this case, you should check "Edit Reference" range in your formula to make sure whether they point to the main sheet or not.
Gia Thinh Technology - Smartsheet Solution Partner.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!