Hi folks, New user here, and loving Smartsheet for the most part. My free trial just ended and I had a bunch of sheets created. I knew I would only have access to two (editable) once the trial ended. …
I'm new to Smartsheets and I've been tasked with going over the SWOT data. They are asking me to go over each category of SWOT with the unique data point they captured and tallying how many times that…
I'm trying to reference another sheet and get a count of items that meet multiple criteria. My formula syntax is =COUNTIFS({173000 High School UUU Model Review Items Range 1}, "3-Critical", {Phase}, "…
Hello, I'm trying to help a colleague set up a metrics sheet that can help them report on the number of skills they have within their department. There's a sheet of all the people in the department, w…
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([Confer…
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-d…
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 us…
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…
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 the…
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 …
