Help

Count Items Based on Color-Code Option in Multi-Select

Topic Labels: Formulas
614 6
cancel
Showing results for 
Search instead for 
Did you mean: 
hkobayashi
4 - Data Explorer
4 - Data Explorer

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

6 Replies 6

Yes, but you'd need a script for this I'm afraid

Sistema_Aotearo
8 - Airtable Astronomer
8 - Airtable Astronomer

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.

Dan_Montoya
Community Manager
Community Manager

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?

Hmm. I'm not much of a coder. Would you explain? 

What would be the best way to do that? Like in the different field and link the records together? 

Dan_Montoya
Community Manager
Community Manager

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.Screenshot 2024-04-23 at 1.43.23 PM.pngScreenshot 2024-04-23 at 1.43.51 PM.png