List field names for non-zero values in record

Ask the community Formulas
#1

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?

#2

Welcome to the Airtable community!

Here is a starting place …

REGEX_REPLACE(
  CONCATENATE(
    IF( NOT( {Field1}, "Field1, "),
    IF( NOT( {Field2}, "Field2, "),
    IF( NOT( {Field3}, "Field3, "),
    IF( NOT( {Field4}, "Field4, ")
  ),
  ", $",
  ""
)
1 Like
#3

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.