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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 505 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!