Including column names in report

[Pratyay_Rakshit]

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?

[Steve]

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("")
)

[Pratyay_Rakshit]

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.

[Steve]

Maybe this?

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

[Pratyay_Rakshit]

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

[Steve]

I don’t understand.

[Pratyay_Rakshit]

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.

[Steve]

I’m afraid I have no suggestions.