Filters in Datashuttle Using Checkbox (True/False)
Some of you may already know this but for several days (weeks if I'm honest), I've been struggling with why the filter in a DataShuttle was not excluding the rows that data issues (i.e. were not checked and cleared to move to the next step). I have the column set up as checkbox and use a formula to check several other columns for completeness, accuracy and number of characters in taxonomy. The trick is that even though in the exported CSV file the column shows the values as TRUE and FALSE, the filters in DataShuttle are case sensitive and require that all be lower case: true and false. I hope this saves you some time if you have a similar situation.
Comments
-
Hey @Amber Grossman
Thank you for posting your solution!
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!