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

[Thomas_Roberts]

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?

[Harry2]

@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]

Ok thanks! at least i can stop chasing my tail