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.
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?
Currently, it’s just another field of type Multi Select within the Person table.
It is hard to get, can you share a screenshot of some lead with some checklist items ticked?
BTW, you may try to use AI in Formulas, it is quite smart and in most cases creates a formula you need
Ideally, I’d like to have a lead fit rate.
But currently I’d like to base their fit on the checklist completion.
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'
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.
I misread the requirement initially, it is possible to do via automations. Here is the solution
And here is the formula in automations that will update the field
ToText([Step 1 Client].[Lead Qualification Checklist].Count()) +
"/" +
ToText([Lead Qualifications].Count())
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!