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