Hey community I’m new to Coda and find the app rather complex than powerful (yet). So maybe you can help me out!
I want to track customer exposure, e.g. how many hours has each employee participated in user research. To do this I’m pushing all new Google Calendar events to a Coda doc. Each event means one row.
The attendee’s emails are a comma separated array which I SPLIT in a select list. That select list grabs the values of the employees also from a master table with all employees.
Now I want to do something like COUNTIF over that table with the select list to count each event which contains a given employees name. However, it looks that COUNTIF doesn’t work for select lists. Any idea how I can achieve my outcome?