Including column names in report

There are question columns with options yes / no.

I want to have a report where I can show all column names that are Yes, for ONE particular row.

Is this possible? If yes, then how?

It’s not inherently possible: there’s no way to get column names from an expression.

Try something like this:

(
  LIST(
    IFS([column1], "column1"),
    IFS([column2], "column2"),
    ...,
    IFS([columnN], "columnN")
  )
  - LIST("")
)
1 Like

This works. It forms a list of values in the format I desire.

But when I print it in a report, what’s the way to do it?

Should I just put in the virtual column name?

I want to print them in lines, not comma separated entities.

1 Like

Maybe this?

SPLIT(
  CONCATENATE(
    LIST(
      IFS([column1], "column1"),
      IFS([column2], "column2"),
      ...,
      IFS([columnN], "columnN")
    )
    - LIST("")
  ),
  " , ",
  "
"
)
1 Like

Can I print out the list column using a start expression?

I don’t understand.

The expression that you provided generates a column with type as list, which contains all the desired entities.

I want to print that list in a report. But not as comma separated entities, but in a table format.

I was wanting to know of way for that.

1 Like

I’m afraid I have no suggestions.