Cell references not updating
Hello,
I have a sheet that uses references to pull in data from another sheet, but after updating the data via Data Shuttle it is not pulling in the new data.
I am pulling in data from previous months so when initially set up it was pulling January and February data, after doing the data update I was expecting it to now start pulling in March data, but it is not. The data for the first two months are still pulling from the sheet, but March is not.
Data Sheet with outgoing links
Sheet that references data sheet with incoming links
Answers
-
What formula(s) are you using to pull in the counts?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi Paul,
Thanks for the response. I figured out that my issue was that the numbers weren't matching up due to some of them being stored as a string versus a number.
-
Hi @Nick Sor
I hope you're well and safe!
I'm glad that you got it working!
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.6K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives