Turning Text into Checked Checkmark Field

Options

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

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓
    Options

    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

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓
    Options

    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.

  • Camille Adriao
    Options

    Hi Mark,

    This worked perfectly. Thank you!

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!