-
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…
-
Join Collect with text
Join Collect is a new one for me and I am struggling... I am wanting to JOIN COLLECT with results only with BFF PM, listing the contact name/card Master sheet: Current formula: =JOIN(COLLECT({Area Contact Range 2}, {Market Area}, [Market Area]@row, {Title}, "BFF PM"), " , ") Reference: