Google Sheets integration, problem with initial single quote in cell

[tobiasbl1]

The problem

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())))”

What version of Home Assistant Core has the issue?

core-2022-11-1

What was the last working version of Home Assistant Core?

No response

What type of installation are you running?

Home Assistant OS

Integration causing the issue

Google Sheets

Link to integration documentation on our website

https://www.home-assistant.io/integrations/google_sheets/

Diagnostics information

No response

Example YAML snippet

No response

Anything in the logs that might be useful for us?

No response

Additional information

No response

[home-assistant[bot]]

Hey there @tkdrob, mind taking a look at this issue as it has been labeled with an integration (google_sheets) you are listed as a code owner for? Thanks!

Code owner commands

Code owners of google_sheets can trigger bot actions by commenting:

• @home-assistant close Closes the issue.
• @home-assistant rename Awesome new title Change the title of the issue.
• @home-assistant reopen Reopen the issue.
• @home-assistant unassign google_sheets Removes the current integration label and assignees on the issue, add the integration domain after the command.

_{^{(message by CodeOwnersMention)}}

---

google_sheets documentation google_sheets source _{^{(message by IssueLinks)}}

[tkdrob]

I will have to look into this. Perhaps you can instead calculate KMSTAND inside the template?

[tobiasbl1]

@tkdrob Hi, thanks. Unfortunatelly I need to insert the formula and not values into some cells

[tkdrob]

@home-assistant close