-
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).…
-
Sheets display up to 100,000 cell link indicators
Hi Community! In August 2022, we limited the number of outbound cell link indicators a sheet can display to 1,000. This change was made for product performance reasons, with no functional impact to your sheet links except for the removal of the visual indicators. Since then, the engineering team has been making significant…
-
Add specific column data to a sheet
I have seven (7) sheets that track dates for activities in our facilities. Not all seven sheets have the exact same columns but they all have certain columns that I would like to consolidate onto a master sheet for reporting and metrics. The copy row automation, as you already know, copies the data for all of the columns.…
-
Datasheet reference URL
I have a column with the link to another datasheet, how can I write the full URL into another column?
-
Ranges
Hi, I am using "Ranges" when I use vlookup etc, but I don't know how to completely delete a Range (or multiple Ranges) Does anyone know how to delete all "old" ranges from within smartsheet memory? I think I need to free-up some resources, I keep getting the error message; "You can only reference 25000 cells" "Please…
