Data Shuttle Export - Inconsistent output for checkbox field
When using Data Shuttle my checkbox fields that are actually checked, do show up as "True" in Excel. However, the unchecked fields sometimes display a "False" value, while most of the unchecked fields appear as "null".
Is there a fix for this? Is there a way to either force all unchecked to be either null, or false? One or the other would be fine, but a mix of both is problematic.
Thank you,
Todd
Best Answer
-
I would suggest reaching out to Support directly in case it is a bug, but at least there is an option (even if not ideal) in the mean time.
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!
Answers
-
It sounds like maybe the boxes that are coming in as "false" were checked at one point and then unchecked whereas the ones coming in as "null" we never checked to begin with? We may need a helper column to output one of two specific values based on the checkbox within the Smartsheet itself before the export.
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!
-
Thank you for your analysis, I did a test, and that seems to be the case. However useful a "helper" column may be, this falls back to Smartsheet support for a fix. They should be able to generate an output based on the actual condition that exists without regard for whether or not the field has been checked in the past.
-
I would suggest reaching out to Support directly in case it is a bug, but at least there is an option (even if not ideal) in the mean time.
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!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives