-
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…
-
How to COLLECT() a different reference value for each value in a multi-select column and SUM() them?
I have a cost matrix similar to this staged one: The cost matrix is referenced in a second sheet of "buyer requests" to determine the cost of their request based on the Type, Size, and Vendor they chose: When only ONE Type of Material is requested, the following formula works: =INDEX(COLLECT({Cost}, {Vendor}, [Preferred…
-
Populate multiple cells in sheet when code matched in another sheet
Hi, i'm totally lost on this one and hope the community can help. I have 2 sheets, 1 and 2. Sheet 1 has column called "code" (unique ref number) and other columns 'color', 'size', 'cost', 'weight', 'location' In sheet 2, i also have column called "code", and 2 other columns for 'color' and 'size' the dream is, when user…
-
Pulling "Assigned" Tasks into one sheet
Does anyone know how to pull tasks assigned to you from one sheet into another sheet?
-
Show added data on charts automatically
Hi We would like to show progress of our tasks within a dashboard. To do so we automatically copy every week status information (number of task that are not started / in progress / completed / on hold) into an input sheet that acts as a log book. I would now like to visualize the progress we make in completing our tasks…
