How to update a cell with a formula?

What would the syntax be in the formula portion of the update be? I'm confused because some of the formulas I work with have the double quote character in it. For example, I have this as apart of my request.

"formula":"=IF([Manager]@row = "Tom Hank", "TM", IF([Manager]@row = "John Oliver", "JO", IF([Manager]@row = "Elvis Presly", "EP")))"

It seems to me that the quotes near names will throw off the syntax of the call and force an error. To avoid this should I replace them with the single quote ( ' ) or do I need make sure it gets sent in as an escaped double quote ( " )? I can't seem to find an example of the syntax online so hoping to get some clarification

Just a heads up, I didn't write this formula, I just need to work with it.

Find more posts tagged with

Sheets

API and Developers

Formulas

Comments

Andrée Starå

Hi,

The "Text" is used with text to get an exact match or to have text shown as part of the formula or to show an empty cell.

Do you get an error message? Can you share a screenshot or the sheet?

I hope this helps you!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Jose Cardenas

Yeah so the error I get is as follows

{ "errorCode": 1008, "message": "Unable to parse request. The following error occurred: Field \"cells\" was not parsable. Unexpected character ('T' (code 84)): was expecting comma to separate OBJECT entries\u000A at [Source: java.io.PushbackInputStream@7dd855b8; line: 1, column: 551].", "refId": "ou982b9axv5t" }

I checked the column that it would be in (551) and it points at the 'T' in "Tom Hanks"

IF([Manager]@row = "Tom Hank", "TM", IF([Manager]@row = "John Oliver", "JO", IF([Manager]@row = "Elvis Presly", "EP")))

I'm assuming that the formula field parses, hits the Double quote just before the T and assumes that the formula is finished. It expects a comma but of course I'm trying to use the Quote to reference exact match for the column in the row.

Andrée Starå

I'm sorry, but I thought that this was in a cell on the sheet, but I see now that you've marked it with API.

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…