-
Error 5262: "Unable to create the requested cell link(s). The source data is no longer accessible."
Hi, I'm getting this error message when attempting to create a link from a cell in another sheet (through creating a cell, a row, and then update_rows method). Has anyone seen this error? I'm reading a discussion on another thread that this error is related to some issue with profile data (?), but I can create this link…
-
How to link specific fields from one sheet to another sheet?
Sheet #1 has two Columns, let's say they are titled "Name" and "Fruit". Under "Name", is a list of names i.e. Mitch, Sarah, Elizabeth, Pete etc. Under "Fruit" says apple, orange, kiwi, etc. I want to create a new sheet (Sheet #2) that could reference Sheet #1. For instance, if column "Fruit" in the first sheet says…
-
Create a Drop-Down List from Another Smartsheet
Greetings! Does Smartsheet include a feature that allows for the creation of a drop-down in which the selection choices are pulled from a column in another Smartsheet? Thank you, John
-
One Data Set, Multiple Calendars
I have a sheet set up for publishing to Outlook calendar. "PTO Detail" is the primary column and displays on the calendar. I need to create a second calendar with all of the same dates with the second column "PTO Detail Team". What's the best way to go about this? All of the data is input via a form, and both calendars…
-
Data Mesh scheduling - new row in the target sheet
I have a configuration with Execution Frequency = Immediate and Data Mapping Format = Create Cell Links. When I add a new row to the target sheet, mapped cells do not get their link in the new row. If I change the schedule to 1 Hour, links are added. Q: If all my mapping is Create Cell Links, then I don't need a frequency…
-
Configuring a Metrics Widget - can it be done?
Full disclosure - I have been using the PMO template and modifying it for our needs. It was a great starter, but needed some additional tweaks to suit our purposes. I added a sheet that dynamically collects all the unique names to make it easier to dynamically display them on my dashboard: (a big thank you to @Cleversheet…
-
Have I crashed my system??????
In an effort to remove a cell link, I somehow managed to lock myself out of free text cells. I am able to use cells with drop downs or dates, but I cannot free text in any designated free text cell in any of my workspaces. When I start to type, there is a little blue dot in the upper left corner of the cell that I don't…
-
The Link is not working
Hi, we have a master portfolio summary sheet, it takes data from different sheets. There are two lines strangely doesn't show the linked Data, even though it shows it is correctly linked. I tried to remove the link and link again, still not showing anything. I am not sure how to fix this.
-
Hyperlink-link to other smartsheet
I have a stock summary with over 1000 items and I need to link the Ref no. to the related smartsheet as the following example. How can I create it without enter one by one manually? Also, how can I get the incoming and outgoing from the related smartsheet in a smarter way?
-
Update on Outbound Cell Link Indicators
On August 7th, 2022 we reduced the number of outbound cell link indicators a user can see on a sheet from 100,000 to 1,000. This change turned off the visual indicators (triangle in the bottom right corner of a cell). There is no functional impact to your sheets except for the removal of the visual indicator (triangle).…
