Skip to main content

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 ✅ ✅ ✅ ✅ . Or, if you’ve checked 10 boxes, there would be ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ .



Thanks in advance.

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...

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!

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

Reply


Terms & Conditions