1. Trying to find a way to count how many col...

(Thomas Roberts) #1
  1. Trying to find a way to count how many columns in a row say “corrected” or “reported”

  2. Trying to return the column header of with a “text join” function of each cell in a row that contains “corrected” and/or “reported”

There are too many columns to do it individually. Anyway to do it with a “_thisrow” function?

(Dinh Nguyen Nguyen) #2

@Thomas_Roberts Hi Thomas, there is currently no built-in function to automatically return the column headers, which means that you will need to “hard code” the column headers into your expression.

Also, there is no function/mechanism to programmatically iterate or “cycle” through all of the columns, which again means that there’s no avoiding adding each column individually into the expression.

(Thomas Roberts) #3

Ok thanks! at least i can stop chasing my tail