Sign in to join the conversation:
Has anyone been able to figure out how to do a find/replace on a checkbox type column?
I have tried 1, true, TRUE, True, "1", "true", "TRUE", "True", and none of them seem to trigger a match.
Hi Paul,
Unfortunately, as far as I know, it's not possible at the moment, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
I hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
To add: It's probably possible through the API or Zapier.
I spent more time than I would like to admit trying to figure out why you would want to do this any why it wasn't working for you until I realized you meant the feature not the formulas hahaha
=REPLACE(Checkbox@row, FIND("r", Checkbox@row), 1, 123) = t123ue
Thanks for the input.
.
Andree,
Enhancement request has been submitted.
I am not too concerned with setting something up in Zapier. It is a one-time thing, but it is a rather tedious process.
L@123,
Haha. Yes. The feature. Not the formula.
Here's a rundown of the process and my current solution (was just hoping to cut out a couple of basic steps).
Very long story short, I am building out a "Master" Project Plan that will basically incorporate line items for each of the 14 different services that could be implemented by my team. To keep it from being absolutely massive, duplicate line items have been combined into a single row.
The lead will check off some boxes for which service(s) will be implemented with xyz project.
The project plan contains 14 columns of checkboxes (one for each service). I intend to have a checkbox in the top row that is cell linked to the Charter so that the boxes in row one across these Services columns reflect what the lead has chosen.
I will then have a basic formula referring to row 1 in each of the columns that will check the box @row if row 1 is checked.
To determine which boxes will get checked, I am having to manually go in and enter this formula on these rows for this column and those rows for that column. Some rows have multiple columns checked. Some rows may only have one or two columns checked.
Very tedious to say the least.
Manually checking the correct boxes for each row is much easier than trying to copy/paste, so I was hoping that I could manually check then use a basic Find/Replace on the columns to replace the manual check with the formula.
My workaround is to change the column to a text/number type and run a Find/Replace on 1. Then change it back to checkboxes.
The longest part of that solution is changing 14 column types twice. It really isn't too terrible compared to the overall build. I was just hoping to be able to skip the steps of changing the column types.
Just for size reference...
The Project Plan has grown to over 700 rows and will probably be just shy of 1,000 by the time it is done. All with 14 columns. Ugh.
Anywho... Thanks for the feedback!
Been there done that, wasn't fun!
Zapier is
Thank you for sharing your work around Paul!
Update to your method, you can run a find and replace even with the columns still set to checkboxes.
In my example the data being dropped in was "X." I just did a simple find and replace "X" with "true" and presto, 18 columns and 2000+ rows are now beautiful checkboxes.
Cheers
@Nick Wilson Yes. That works now. My last post on it was pretty old. I was also trying to replace with a formula as opposed to just a "true" value.
Hello I could use some help with this formula. Here is the formula I am using the bright yellow column to hold the formula. so you can see the results of that formula below =IF(ISBLANK([Initial Approval Date]@row ), " ", [Homeowner Approval Initial Status intake]@row + [Homeowner Approval Initial Status Intake 2]@row +…
Hi there, I've created a sheet to where my team is tracking information received. In one column, we are logging the date and time information came in (ie: November 21, 2025 8:30 AM). I would like to add a checkbox column, with a formula specifying that the box be checked if the logged time is AFTER 8:30 AM, and left…
I have a column named Territory, where I am trying to write a formula to populate it when names are chosen from an adjacent drop-down list column called Employee Attendee. If more than one name is selected from the Employee column, I would like their respective territories to populate in the Territory field, separated by a…
