Button formula updated via MCP shows "Unknown reference" for row references (works when edited in the UI)

Hi all,

I’m using the Superhuman Docs MCP server (table_columns_manage) to edit button columns, and I ran into what looks like a reference-resolution issue.

Setup:

  • A table with a button column whose action formula uses a SwitchIf comparing a lookup column to rows of another table, e.g.:
    SwitchIf([Status de entrada] = [Compra novo cliente], …, [Status de entrada] = [Compra com mudança de endereço], …, …)
  • [Compra novo cliente] etc. are rows of a table called “DB Status de entrada”.

What happened:

  1. I updated the button’s actionFormula through the MCP with plain text. The same formula (minus a Round() I changed) was working before.
  2. Afterwards, the formula editor in the UI flags those row references in red: “Unknown reference – We could not find any Table, View, or Control with the name Compra novo cliente anywhere in the doc.”
  3. In the editor the references appear as plain text instead of the blue row-reference chips.
  4. I also noticed that after a write, the MCP returns other formulas in the same table in a normalized form (e.g. Cartela → [DB Clientes].Cartela, thisRow.Cartela), so the stored text seems to be rewritten on the server side.
  5. Re-selecting the references manually in the editor fixed it.

Expected: a formula written through the MCP/API keeps (or re-binds) references to rows of other tables, the same way the editor does.

Question:
Is this a known limitation of formulas written as text through the API/MCP?

My best guess is that this is a limitation of the MCP. I run into this issue a lot too, where my row references are written in plain text.

To mitigate this, I’ve used the workaround of, at first, explicitly telling whatever LLM I’m using to write with the $$ reference syntax, or Coda Formula Language’s direct representation of a row reference: ($$[row:tableId::rowId:bool])

…and then creating a skill file with that information so that the LLM doesn’t get tripped up on writing it in the future. You can actually extract this reference for yourself by using _SERIALIZE_ROW_AS_FORMULA(thisRow) as a column formula. The row reference syntax is essentially a concatenation of $$[row:tableId:: + thisRow._ROW_KEY()].

This has worked for me thus far, but it’s only that: a workaround. I’d like to see this fixed sometime soon.