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! Book time with me here: https://calendly.com/michelle-choate
-
@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
- 66.7K Get Help
- 436 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Trending Posts
- I have a Dynamic View that is filtered using the "Restrict view by sheet filter" so the view only shows a certain users assigned projects. Each project has one or more resources. The "resources" colum…
- Hey! This automation was working fine - but now that I've ensured that as i look to leave the company we have better owners, i can't select this sheet. They're in 2 workspaces, which wasn't a problem …
- Under the User Subscription Model, can internal collaborators designated as viewers (not members or guests), enter data into a dynamic view? Our group is still on the Legacy Collaborator Model and use…
