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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!