How do you get a data shuttle filter to work on a column with a formula?
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!
Best Answer
-
@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!
Answers
-
Have you tried using lower case "true" for your filter?
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
-
@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! -
@ChristianFinke Your helper column solution worked! Thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives