Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 22, 2024 07:25 PM
Hello!
I have a list of names under a multi-select. Everyone in Blue is a FT staff member, everyone in yellow is a contracted worker. I want a count field (or formula field) that will automatically count all the Blue multiple select to give me the total number of FT workers, and another field to count the Yellow multiple selects for the total amount of contract workers. Is this possible?
Best,
H
Apr 22, 2024 07:56 PM
Yes, but you'd need a script for this I'm afraid
Apr 22, 2024 08:19 PM
There's likely a work around for this. Though, it may be quite cluncky.
You could use a "Switch" formula to output the category for each of the single select options. Then use that field to do your calculations.
Apr 23, 2024 12:41 AM
At some point you must have put each FT in a blue select and each contractor in a yellow select. If you are doing this manually, why not do it to a different field which has the values FTE and Contractor in them?
Apr 23, 2024 11:40 AM
Hmm. I'm not much of a coder. Would you explain?
Apr 23, 2024 11:41 AM
What would be the best way to do that? Like in the different field and link the records together?
Apr 23, 2024 01:44 PM
Here is a nocode solution to count the number of faculty and staff I put together a few months back. You can use this model to count your FTE and CW. You can copy the base to your workspace to practice with it.