I want a field that tells me if a volunteer shift is full, using the Volunteers Needed number field and the Volunteers Assigned linked records field.
If I could write the code in plain English, something like:
IF [number of records in Volunteers Assigned] is equal to or greater than {Volunteers Needed}, then display “YES”, IF lesser than, then display “NO”
Checkbox field checked/unchecked instead of “YES” or “NO” text would also be cool but not necessary.
I can figure out the IF part, but can I get the [number of records in Volunteers Assigned] just in the code, or do I need a Count field to find that and then use that Count field in the formula?
