Countif and countifs not updating
I have created a smartsheet with a number of different formulas in to pull together monthly figures. I then use this information to populate charts in my sights. One view I use is to count the number of new jobs added each month. This was working great until latest update.
When I look at my sight the chart is no longer there and says source data file removed. I go into the smartsheet and see invalid data type error. Click in the sheet and the data refreshes and displays itself. Go back to sight and chart now works.
Carry on using smartsheet revisit sight same problem loss of data.
Sumifs on the same sheet work perfectly all the time?
Comments
-
Hi Rob,
Contact our Support team to further troubleshoot the issue that you're experiencing with your Smartsheet dashboard.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!