I have a Lookup which points to a Checkbox field on another table. The Lookup returns a ‘tick’ character for each of the records where a tick is present.
(The field called “Present” is the Checkbox. The ‘tick’ characters that are returned can be seen beneath the ‘Cancel’ button.)
What formula should I use in order to return a count of the number Checkboxes which have been ticked?