How does Work Insights calculate column totals?
I need to know what would make a row show up as "Blank" in the column snapshot. The initial snapshot show the correct column totals but also included a Blank column with a count of about 700. I entered a filter for "Does not Contain "=" because I figured it was counting formulas in blank rows, and that lowered the blank column from 700 to about 328. I then tried to enter another formula saying "Does not Contain" "" to see if that would filter out the rest of the blank columns but that didn't work. I'm trying to think of what else the Column Snapshot is counting for that blank column.
Answers
-
Those are the two filters that I would suggest: does not contain "" and does not contain "="
It's difficult to know what's happening without seeing your actual sheet data: the column being used in the snapshot, column type, what formulas are being used, etc.
I would suggest that if adding those two filters has not removed the "Blank" column (after saving & refreshing etc), then you may want to follow-up with Support where you can share full screen captures and perhaps a screen recording of your sheet and its data. They'll be able to troubleshoot with you in a private channel where you can share this data.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
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