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!
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!