-
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…
-
Dashboard not updating after Sheet changes
For a number of years, our team has been reliant on a PDF Dashboard to issue to our clients. Recently, we have noticed that after new data is input into a Sheet, the Dashboard no longer reflects these changes automatically. Our system is programmed to work in the following manner. (A three-step process -…
-
Managing Multiple Weekly Update Requests
Hi - Wondering if anyone here can help. Our IT organization has a master source sheet tracking all the project requests for the team. Requests are made through a Smartsheet form which inserts a row on the master source sheet. As part of the development request, the PMO send out weekly automated update request to each of…