-
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…
-
Copy a certain columns to a new sheet as new rows are submitted
I have a master sheet that contains information submitted via a form. I am wanting to have a new sheet that contains only certain columns of information that populate as the data on the master sheet is entered. I only need specific columns of information, not every column in the row on the master sheet. Any ideas on how to…
-
Contact type column across multiple sheets
I have a list of contractors that is constantly being updated, from when they are on-boarded, to when they are deactivated. I would like them to be entered as a contact type column. I have multiple sheets where I want this column to be identicle, and also want that when I update Sheet A and add a new contractor and their…