Global Update Find/Replace for a checkbox column?
I'm trying to run a Control Center global update to Find / Replace a value in a checkbox column. I want to find certain rows and if the checkbox column is unchecked, to check it. I've tried a few different combinations of settings, none of which have worked.
See my screenshot for my most recent (failed) attempt. Any advice is greatly appreciated!
Answers
-
Try finding false and replacing with true.
-
@Paul Newcome - Thanks for replying. I did try that earlier, and I just tried it again to be sure - it doesn't work either.
-
I may have found a way around this - not the way I had imagined it, but should work. Since I'm using a "Rpt" column to select which rows should appear in a report view via a filter (Rpt = checked) - instead, I'm going to try changing the report filter to use "is one of" and just manually pick all the row entries I need defined in the report view, and then run a global update to update the report (which I know works).
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 460 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