Hi, I have a problem when writing to my google sheet, that the formula on the last line below will be writtes in the cell as ’ =INDIRECT((address(row()-1,COLUMN())))
in other words a quote as first character in the cell.
How can I insert the = as first character?
service: google_sheets.append_sheet
data:
config_entry: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
worksheet: Trips
data:
TYPE: START
DATE: “{{ now().strftime(”%Y-%m-%d") }}"
TIME: “{{ now().strftime(”%H:%M") }}"
ADRESS: “{{ states(‘sensor.carlocation_czu22x’) }}”
KMSTAND: “=INDIRECT((address(row()-1,COLUMN())))”