How do you get a data shuttle filter to work on a column with a formula?

melissagxpo

I'm trying to set up a data shuttle to filter out any studios that do not have "Send Survey?" checked. I've tried using "Send Survey? equals 1" and "Send Survey? equals True" and both don't work. Any help is appreciated!

ChristianFinke

@melissagxpo

The issue might be that the "Send Survey?" column is formula-driven, and Data Shuttle doesn’t always interpret formula outputs correctly. To resolve this, try adding a helper column to convert the checkbox formula output into plain text or numbers (e.g., IF([Send Survey?]@row = 1, "Yes", "No")). Then, set your Data Shuttle filter to look for the plain text value (e.g., "Yes"). Let me know if this works or if you need further assistance!

Michelle Choate 2

Have you tried using lower case "true" for your filter?

ChristianFinke

@melissagxpo

The issue might be that the "Send Survey?" column is formula-driven, and Data Shuttle doesn’t always interpret formula outputs correctly. To resolve this, try adding a helper column to convert the checkbox formula output into plain text or numbers (e.g., IF([Send Survey?]@row = 1, "Yes", "No")). Then, set your Data Shuttle filter to look for the plain text value (e.g., "Yes"). Let me know if this works or if you need further assistance!

melissagxpo

@ChristianFinke Your helper column solution worked! Thank you!