-
Flag duplicate titles but not if the title is blank
Hiya, I am trying to write a formula that flags entries if the content of the title column is repeated, but I need it to ignore entries that have a blank title. My current one is: =IF(COUNTIFS([Conference Title]:[Conference Title], [Conference Title]@row > 1, [Conference Title]:[Conference Title], [Conference Title]@row) =…
-
Customizable Permissions
Often times I find that I need to give further permissions to users, but don't want to give them unfettered access to sheets. Often times my Project Managers need to add an additional item to a drop-down menu, add an additional column to track a specific need, reorder columns to fit their needs, or adjust lanes in card…
-
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
