# Formula field - checklist count **URL:** \ **Category:** Get Help\ **Created:** [August 19, 2025, 5:03pm UTC](https://community.fibery.io/t/formula-field-checklist-count/9426 "2025-08-19T17:03:32Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![myg\_ge](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/myg_ge/32/12457_2.png) [@myg\_ge](https://community.fibery.io/u/myg_ge)\ **Post date:** [August 19, 2025, 5:03pm UTC](https://community.fibery.io/t/formula-field-checklist-count/9426/1 "2025-08-19T17:03:32Z")
Hey guys, I’m new to Fibery and am completely seduced by both simplicity and complexity in terms of possibilities + UX speed wise… I use Fibery currently as my crm. Each lead has a lead qualification checklist linked to it. Assume, there are 10 criteria points to verify each lead against. Just 4 checked/selected. I want to show “4/10” in my formula field. How do I do that given that .Count() function only shows the selected ones (4)…? Thanks. ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [August 19, 2025, 5:05pm UTC](https://community.fibery.io/t/formula-field-checklist-count/9426/2 "2025-08-19T17:05:53Z")
Hi, if you mean by checklist real checklist in rich text, then Fibery can’t really create formulas around rich text content. If checklist is some list of items linked to a lead via relation, than it is very easy to do, so how you store checklist now? ---
**Author:** ![myg\_ge](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/myg_ge/32/12457_2.png) [@myg\_ge](https://community.fibery.io/u/myg_ge)\ **Post date:** [August 19, 2025, 5:08pm UTC](https://community.fibery.io/t/formula-field-checklist-count/9426/3 "2025-08-19T17:08:35Z")
Currently, it’s just another field of type Multi Select within the Person table. ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [August 19, 2025, 5:10pm UTC](https://community.fibery.io/t/formula-field-checklist-count/9426/4 "2025-08-19T17:10:41Z")
It is hard to get, can you share a screenshot of some lead with some checklist items ticked? ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [August 19, 2025, 5:20pm UTC](https://community.fibery.io/t/formula-field-checklist-count/9426/5 "2025-08-19T17:20:53Z")
BTW, you may try to use AI in Formulas, it is quite smart and in most cases creates a formula you need ---
**Author:** ![myg\_ge](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/myg_ge/32/12457_2.png) [@myg\_ge](https://community.fibery.io/u/myg_ge)\ **Post date:** [August 19, 2025, 5:36pm UTC](https://community.fibery.io/t/formula-field-checklist-count/9426/6 "2025-08-19T17:36:14Z")
Thanks for your supersonic reaction! There you go ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/1/16f85902f4d5f0dc75bec47ad60989343049c9d7.png) ---
**Author:** ![myg\_ge](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/myg_ge/32/12457_2.png) [@myg\_ge](https://community.fibery.io/u/myg_ge)\ **Post date:** [August 19, 2025, 5:41pm UTC](https://community.fibery.io/t/formula-field-checklist-count/9426/7 "2025-08-19T17:41:31Z")
Ideally, I’d like to have a lead fit rate. ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/8/8135e7ff785141acf198d8ad7a58b9c498ecd923.png) But currently I’d like to base their fit on the checklist completion. ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [August 19, 2025, 8:35pm UTC](https://community.fibery.io/t/formula-field-checklist-count/9426/8 "2025-08-19T20:35:46Z")
> [@myg\_ge](#): > > Assume, there are 10 criteria points to verify each lead against. Just 4 checked/selected. I want to show “4/10” in my formula field. How do I do that given that .Count() function only shows the selected ones (4)…? If it’s a multi-select field with fixed options, then presumably the maximum is always 10, right? If so, you can either just divide the count by 10 and choose to display as a percent, i.e. 40% Or you can make a text string: `ToText(MultiSelect.Count()) + '/10'` ---
**Author:** ![myg\_ge](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/myg_ge/32/12457_2.png) [@myg\_ge](https://community.fibery.io/u/myg_ge)\ **Post date:** [August 19, 2025, 8:38pm UTC](https://community.fibery.io/t/formula-field-checklist-count/9426/9 "2025-08-19T20:38:33Z")
Thanks for your idea. I knew I could “hardcode” the max number of points. But I’d like it to be flexible since this is not the only use case. ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [August 20, 2025, 7:20am UTC](https://community.fibery.io/t/formula-field-checklist-count/9426/11 "2025-08-20T07:20:15Z")
I misread the requirement initially, it is possible to do via automations. Here is the solution https://www.loom.com/embed/7af09407bc02427d809d38628ff1bf71?sid=d5d66c8a-2d47-4e0f-b3f4-958cc451c4a5 And here is the formula in automations that will update the field ![Screenshot 2025-08-20 at 10.20.08 AM](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/c/c5b4603351f6af2f5c456e1396d19fb2183c3155.png) ```auto ToText([Step 1 Client].[Lead Qualification Checklist].Count()) + "/" + ToText([Lead Qualifications].Count()) ``` ---
**Author:** ![myg\_ge](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/myg_ge/32/12457_2.png) [@myg\_ge](https://community.fibery.io/u/myg_ge)\ **Post date:** [August 20, 2025, 11:44am UTC](https://community.fibery.io/t/formula-field-checklist-count/9426/12 "2025-08-20T11:44:20Z")
Hey Michael, Thanks so much. I have completely forgotten about the Rules. 🙂 I use them already, just didn’t think of them for my specific “Formula” use case. Thank you guys for your support - highly appreciate your prompt responses - it’s gold for early-stage startups!