-
Index Collect Permissions
Hi all, I have a Smartsheet which looks up values from another sheet using Index Collect, which is working well. However other users with Smartsheet license and with a free license will be loading the sheet who don't have access to the source data sheet. I don't plan in opening the this (the destination sheet) hoping that…
-
Numerical "Priority" Method
Hello, I am in need of a method for assigning priority of a submitted row 1-10. If 1 is selected, the previous 1 needs to become a 2, the 2 becomes a 3, etc. The column needs to recalculate when a row is complete and the 'priority' column becomes blank. I don't think this would be possible without using many columns to…
-
Employee In Take Form: Trying to auto check selections based on 1 and 2 column criteria.
I have many columns created with a checkbox. Ten columns are labeled as required devices for employee types. [Employee type column named "Role"] When a certain employee type is entered in the "Role" column the "Devices" column check boxes would be auto selected showing what devices are required for that Role. Example: If…
-
Cell Linking based on criteria
Hi, I'm looking to link rows and/or cells from one sheet to another based on certain criteria (e.g. if cell in col X = a certain value, link that row to another sheet). Is this possible?
-
Update a cell on a master list from individual identical laid out sheets
I have a template that I use to create data sheets for unique projects. All rows and columns are the same for each project. I also have a master sheet that lists all the projects which are populated with information from the same cell location from each project sheet. I have been able to go from the master sheet to the…
-
Cell Linking? Index/Match?
I have 83 project schedules in a folder. I have a 'Key Milstone' Tracker with project locations in the primary column and all the milestones I need to grab as columns. Each milestone I need is in the exact same place on each of the 83 sheets. Is there an easier way of linking the cells other than sheet by sheet; or some…
-
Countifs with Multiple Criteria
Hi - I need assistance with building a =COUNTIFS formula with multiple criteria. Here is my current equation (that I am getting a '0' on) Current Equation: =COUNTIFS({B23 Delegation Registration Status Region}, "SOAF", {B23 Delegation Registration Status Registration G}, "Athlete" + "Unified Partner" + "Medical Staff" +…
-
Pulling information from second sheet based off one criteria and and if it falls between two numbers
I have one sheet that has job title, salary and then a column called Thirds location where I want to pull in information from another sheet and have it say lower third, middle third or upper third. On the other sheet I have the salary ranges and then broken into thirds. For example, For sally Gold, I want to reference the…
-
What is the best way to copy Workspaces
Hi everyone, I am looking to create copies of some of my Workspaces and am facing 2 different issues. The 1st issue is I have a large interconnected Workspace with over 200 items inside it. I need an exact copy and don't want to relink everything as I would need to do this multiple times and would be days of work. The 2nd…
-
Combine values from multiple drop-downs into one field
Hi there! I'm looking to combine values from 3 separate columns into a single column. The three primary columns all are enabled to have multiple values per cell. The goal is to combine these three columns into one overall "Subcategory" column. Example: Request Type 1 = Apples, Oranges, and Carrots Request Type 2 = Milk…
