Cell link destination display tool by API

table of contents

API Service ToolsAs the first introduction, we will explain the cell link destination display tool by API.
(Note: As shown below, XNUMX links have been restored, and the original significance has diminished, but for example, by leaving a record in the conversation that the cell link is not maintained by backup, backup to Excel etc. However, since the conversation part is saved, I thought that it would be a clue to recovery, so I decided to continue displaying the article.)

With this tool, you can check the cell link information exceeding the outbound cell link display limit (currently XNUMX*) in line comments (conversation). (It is said that it returned to XNUMX on April XNUMX, XNUMX.记事is posted. )

What is Celllink

By using cell links, you can share data such as "extract a specific value from one sheet and make it read-only on another sheet."In other words, you can access the data, but not change the contents, when it is imported by cell linking.

Organize data from multiple sheets to organize and display data from multiple sheets in a dashboard.There are various ways to use it, such as performing rollup calculations across multiple sheets.

Commentary article about cell linkHere.

Current outbound display (indicator) limit

Of SmartsheetHelp article"Smartsheet displays up to 10,000 such indicators for outbound links."

The image below shows that there are actually 24 sheets with 20 cells and a total of XNUMX outbound cell links, with a maximum display of XNUMX. (Originally, up to Target XNUMX should be displayed, but up to Target XNUMX is displayed.)

Below is the workspace used for the test, showing a sheet with 10000 inbound cell links from the XNUMX original "XNUMX cell lin out limit test" sheets, XNUMX x XNUMX A total of XNUMX outbound cell links have been configured.

test-24-cell-link-in-sheet-with-500-links

Discussions in the Smartsheet Community

This outbound cell link display limit was suddenly introduced last year (XNUMX) in August, at which point the maximum number of displays was XNUMX, affecting the customers I support, and also the community However, various discussions were exchanged that "I was in trouble". (Various discussions were exchanged, but thisDiscussionThen, on the second page, Cloudsmart reports that the upper limit has been raised to XNUMX and XNUMX. )

After that, the upper limit was raised to XNUMX or XNUMX. is.

A Smartsheet employee explained in a community post that the change was made to improve Smartsheet's performance.Certainly, holding a large amount of cell link information may slow down the operation of the sheet, but customers were using outbound cell links for various purposes more than the development team expected. It seems that.