Turning Text into Checked Checkmark Field

Camille Adriao

Hello. How would I turn a "Y" text field into a checked checkmark column? Thank you.

Mark Cronk

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

Mark Cronk

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

Camille Adriao

Hi Mark,

This worked perfectly. Thank you!

Mark Cronk

Glad you found a solution. Thank you for contributing to the Community.

Mark