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.
It would be great if the COUNTIF and the COUNTIFS formulas were implemented in Airtable. I use them in most of my excel spreadsheets, and it is a little frustrating not being able to use it here. Are there any plans to add more formulas?
My workaround right now is to create a field for each status I need to count then roll them up in a related table.
Example: Employee Status field is Active, Inactive, Starting, or Leaving. I create 4 hidden formula fields with If(Status=“Active”,1), If(Status=“Inactive”,1), etc then I can do a Rollup field on those fields to Count(values) or Sum().
@Jason_Friedlander
Suppose you have a table of Tasks that can have a {Status} = “Complete”.
Supposed you have a table of Projects that can have many linked Tasks.
In your Tasks table, create a formula field; let’s call it {Complete?}:
IF({Status} = "Complete", 1)
In your Projects table, create a Count field, let’s call it {Total Tasks}, that counts the total number of linked Tasks.
In your Projects table, create a Rollup field, let’s call it {% Complete}, that rolls up like this:
Table = Tasks
Field = {Complete?}
Agg Function = SUM(values) / {Total Tasks}
Format that Rollup field as a Percentage field in the “Formatting” menu.
(Now just convert terms to whatever your schema is… “Tasks” = “Responses”, “Projects” = ???)