Note!
For better performance with your data, upload it to MaviBot tables. This way, your bots will work much faster and avoid errors related to requests to Google Sheets.
For working with column letters
c2n() | n2c() | addCols()
To get a column number by its letter
c2n(str)
Parameters:\ ! str - column number in letter notation
To get a column letter by number
n2c(n)
Parameter:\ ! n- column number as a numeric value
To get a column letter by offset from a given column
addCols(str, n)
Parameters:\ ! str - column letter
n - offset; to get a column number to the left of the specified one, pass a negative offset value.
number=c2n('AAB')
string=n2c(54)
offset=addCols('AA',-1)