Unable to disable DataTable connections to sheets. Has anyone encountered this?

Chris Barsegyan

I have not had any issues in the past with disabling the connections.

I have 30 sheets with connections, when I disable the connections they show disabled but after a few minutes they become active on there own.

The sheets have many connections to them via formulas (index/match) and smartsheet apps (dynamic view, data mesh, pivots, reports, etc.)

If anyone has encountered this or has any suggestions please share your thoughts.

Thanks,

Danielle Wilson

@Chris Barsegyan I haven't heard of that happening! Could you please submit a Smartsheet Support Ticket to have that investigated if you're still having the issue?

Best,

Danielle W.

Product Marketing

Smartsheet

Nurul MohdYusoff

@Chris Barsegyan I am having the same issue too! Even when I delete the connection (filter mode) and create a new connection (lookup mode) with another datatable, the deleted connection was restored after a few minutes.

In my datatable tab, the connection count is showing as minus.

Chris Barsegyan

@Danielle Wilson I submitted a ticket for this issue on 1/24/23, the tier 2 rep is in the process of escalating to tier 3.

@Nurul MohdYusoff I was told there are multiple calls being pushed to the sheets which is causing the connection to activate. I have tried disabling all premium app connections and auto workflows to my sheets, deleting and recreating the datatable connections, and clearing cache- nothing worked, which is why I thought to post about it to see if others might be experiencing the same issue.

I do not show negative connection counts.

Danielle Wilson

@Chris Barsegyan Thank you for the update! I spoke to the Product Manager earlier today and she mentioned that this was a known issue that was being escalated by Engineering. So you should have some updates shortly!

Nurul MohdYusoff

@Danielle Wilson I've submitted the ticket last week and the same issue still happening now. One of the connections affected our Global Travel Authorization Request sheet and it messed up all the info that should be in the approval requests alert that is being sent to the exec leadership. Hope this can be solved soon!

Danielle Wilson

@Nurul MohdYusoff Thank you for the update! I'll pass that along to the Product Manager for DataTable.