Skip to main content
Solved

How to Add 1 Emoji for Each Checkbox that is Checked

  • February 26, 2020
  • 3 replies
  • 33 views
R
Forum|alt.badge.img+1

I have 10 checkboxes in my table. Each checkbox corresponds with a task that needs to be completed.

I’d like to build a formal that shows an emoji each time another checkbox is checked.

For example, if you’ve checked 4 boxes, there would be :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: . Or, if you’ve checked 10 boxes, there would be :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: .

Thanks in advance.

Best answer by Jeremy_Oglesby

Hi @RJ_Martino.

You’d have to check the state of each checkbox field by name, and then output your emoji based on the state. So something like this:

IF({Checkbox Field 1}, "✅") &
IF({Checkbox Field 2}, "✅") &
IF({Checkbox Field 3}, "✅") &
etc...

    3 replies

    J
    Forum|alt.badge.img+18
    • Jeremy_Oglesby
    • Inspiring
    • Answer
    • February 26, 2020

    Hi @RJ_Martino.

    You’d have to check the state of each checkbox field by name, and then output your emoji based on the state. So something like this:

    IF({Checkbox Field 1}, "✅") &
IF({Checkbox Field 2}, "✅") &
IF({Checkbox Field 3}, "✅") &
etc...
    R
    V
    J
    R
    Forum|alt.badge.img+1
    • RJ_Martino
    • Author
    • New Participant
    • February 26, 2020

    Hi @RJ_Martino.

    You’d have to check the state of each checkbox field by name, and then output your emoji based on the state. So something like this:

    IF({Checkbox Field 1}, "✅") &
IF({Checkbox Field 2}, "✅") &
IF({Checkbox Field 3}, "✅") &
etc...

    Great Stuff! Thanks for the help!

    J
    kuovonne
    Forum|alt.badge.img+29
    • kuovonne
    • Brainy
    • February 26, 2020

    The formula from @Jeremy_Oglesby is a fine suggestion. However, it can be a bit difficult to see the difference between 9 and 10 check box emoji at a glance.

    Another method would be to use a formula field count the number of check boxes and then use other formulas based on that.

    Create a {Num Tasks Done} formula field that counts the number of check boxes. Notice that it is very similar to Jeremy’s. However, you can directly add the check boxes together. If a box is checked, its value is 1; if unchecked, its value is 0.

    {Checkbox Field 1} + {Checkbox Field 2} + {Checkbox Field 3} ...

    Then you can generate your emoji field with the formula

    REPT("✅", {Num Tasks Done})

    You can also create a formula to show the status:

    IF({Num Tasks Done} = 0,
  "Not started",
  IF({Num Tasks Done} < 10,
    "In Progress",
    "Done"
  )
)

    Or a formula to show percent done (select percent as the format for the field):

    {Num Tasks Done} / 10
    Terms & ConditionsAccessibility statement