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?
-
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
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives