Help

Is there a way to access the names of columns?

Topic Labels: Formulas
2943 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Jamee_Bateau
4 - Data Explorer
4 - Data Explorer

Is there a programmatic way to count columns? I am aware that COUNTA() exists, but I have to manually input the column names into the formula. Is there a way I can access the names of the columns and count the ones that contain the word “Siege” for example?

3 Replies 3
Tuur
10 - Mercury
10 - Mercury

The most basic example that does exactly what you want: create a new column with the following formula. The total will be displayed at the bottom of this column.

IF(FIND("Siege", Name), 1, 0)
Jamee_Bateau
4 - Data Explorer
4 - Data Explorer

Hello, Tuur. Thanks for the reply. I believe that will only find data in a cell. I wanted to somehow look at the name of the COLUMN and count the columns names that contain the word “Siege.” It doesn’t look like that’s possible.

Ahhh. Sorry about that. And nope, not possible. Sorry about that too…