This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi everyone,
I’m using Airtable to help reformat some .csv attendance sheets that are a pain. There is only one export option that comes in as Person ID for the primary field, then each event comes in as a text field with an X to mark attendance.
I...
…and now I’ve figured out how to make nested FIND formulas within a SUM formula.
For the record, and in hopes it helps someone else, I did…
SUM(
(FIND(“X”, {Jan 8, 2019 AM Meeting})),
(FIND(“X”, {Jan 8, 2019 PM Meeting})),
(FIND(“X”, {Jan 15, 2019 AM...
