Turning Text into Checked Checkmark Field
Hello. How would I turn a "Y" text field into a checked checkmark column? Thank you.
Best Answer
-
Hi,
Insert a checkbox column [Box] to the right of your other column. Enter the column formula:
=IF([Checkbox]@row="Y", 1, 0). Replace [checkbox] with the name of your column with the Y values.
The [Box] column should now have a check when the [Checkbox] column contains a Y.
Highlight and copy the [Box] column. Paste Special into the [checkbox] column as Values.
Delete the [Box] column.
Work?
Matk
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi,
Insert a checkbox column [Box] to the right of your other column. Enter the column formula:
=IF([Checkbox]@row="Y", 1, 0). Replace [checkbox] with the name of your column with the Y values.
The [Box] column should now have a check when the [Checkbox] column contains a Y.
Highlight and copy the [Box] column. Paste Special into the [checkbox] column as Values.
Delete the [Box] column.
Work?
Matk
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Hi Mark,
This worked perfectly. Thank you!
-
Glad you found a solution. Thank you for contributing to the Community.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
Check out the Formula Handbook template!