Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

List field names for non-zero values in record

Topic Labels: Formulas
171 1
Showing results for 
Search instead for 
Did you mean: 

I’m trying to list the field names for which non-zero values appear in each record. I would have used a combination of Match and Index in excel… What would be the solution in Airtable?

1 Reply 1

Welcome to the Airtable community!

Here is a starting place …

    IF( NOT( {Field1}, "Field1, "),
    IF( NOT( {Field2}, "Field2, "),
    IF( NOT( {Field3}, "Field3, "),
    IF( NOT( {Field4}, "Field4, ")
  ", $",