-
Sharing in Sheets
My team currently has a business license. I have 3 different sheets that I need to share with 6 people who do not have licenses and will only be considered editors. If I share the sheets with the 6 users, will they each need to keep up with the original email link from smartsheet in order to continue to access the sheets?…
-
Count IF function not working
Hi, I am trying to create a count if function that will count all the cells that include text in a row, but not if that text is "NONE" or "CURRENT REQ" I've gotten this far, =COUNTIFS(Taleo11:[Media 5 Request]11, OR(@cell = "NONE", @cell = "CURRENT REQ")) but the formula keeps returning 0 no matter what is in the row. Can…
-
Using a sheet as a master for other sheets
Hello, we have a 'Current Employees' Smartsheet which lists all employees with certain information such as Start Date, Contact Details, etc. If an employee finishes we enter a Finish Date and this then automates them (that row) being moved to another sheet. What we are trying to achieve is to use the above 'Current…
-
Cell-linked dates don't go away when I delete the source
I have a sheet (The Milestone Sheet) that is made up mostly of cells linked to another sheet (The Schedule). The 'start date' column in the Milestone sheet is referencing the 'due date' column in the Schedule. I set the 'duration' column in the Milestone sheet to 0 for every row, which makes the due date the same as the…
-
Averaging RGB balls
I'm hoping this is quite simple, but my simple mind is struggling to piece it together. I have a Parent Row with multiple Children but only one hierarchy below it and i want the parent row to average the status of the Red, Green and Blue balls on the Children rows...make sense? Help would be much appreciated, screen shot…
-
Historic Project Status Tracking on Multiple Projects
Hello, We want to track the project status over multiple years on one sheet for all current projects (around 200 projects). We currently have this tracker in Excel with columns for each week that continue on for each week and 'roll behind' the other columns needed for the sheet, such as project name, client, PM, etc. Is…
-
Has anyone turned into the Employee Onboarding template into a rollup format?
Hi all, I'm working on a project for Employee Onboarding. After discussing with stakeholders, I think the Employee Onboarding template (Setup: New Employee Onboarding - Smartsheet.com) is a great start, however it doesn't meet some of the needs we are looking to cover. I'm reaching out to the community to see if anyone has…
-
Double Dependency
If I have a task that starts when one task finishes, but needs to finish at the same time as another. Is that possible in Smartsheets? when I include a SF with one Task, and FF with another it calculates a (1) day value and finishes with the task associated with FF
-
How to add columns based on user input from another column?
I have a field called Number of Children in my form. The user then inputs the number of children they have. What I am looking to do is have other fields added based on what the user input for the Number of Children field. For example, if the user inputs 4 in the Number of Children field, I want a Name, Age, and Gender…
-
Transferring Ownership of Multiple Sheets/Reports/Dashboards at once
Hello, I've got a scenario where I helped a user (let's call him User 1) create a process, however, he (User 1) has switched positions and it is time to reassign ownership of things to another individual (User 2). Between me and the original user (User 1), we created all the sheets, reports, and dashboards in the…
