Column headers in google sheets

#1

Hi, I’ve noticed that if I use numbers as column headers in google sheets, the values come out similar to this:

one: 17, two: 6, three: 4, _ciyn3: 3, _ckd7g: 2, _clrrx: 8

(the actual column headers above are (one, two, three, 4, 5, 6)

Is there a way to maintain the numbering system so I can use those numbers in the code service to specify a particular column?

(Daniel Beckett) #2

@Starboy73

With the Google Sheets service, numbers at the end of column names are known to cause problems and should be avoided (for example, ‘Timesheet1’).

An alternative naming convention for your column headers would be best, even if it’s just appending the numbers with a letter, e.g:
1a, 2a, 3a, 4a…

1 Like