Yes, but you'd need a script for this I'm afraid
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.
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?
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.
Hmm. I'm not much of a coder. Would you explain?
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?
What would be the best way to do that? Like in the different field and link the records together?
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.
