-
Count and then Rank multiple text values in same Cell in one Column
I have been scouring the community page looking for help with this question and plan to set up a Pro Desk appointment, but they don't have any availability until next week so any help is appreciated. I have a form collecting data into a sheet and then a separate calculations sheet. I am trying to 'count' within a column…
-
Using Vlookup where search value contains multiple values (column is a drop down)
I have a main sheet where i want to select "Plants for Consideration", then after selecting a production plant the emails of the people involved will populate in another cell. I've created a separate smartsheet to reference which has the column on the far left "Plants for Consideration" and then in another column (column…
-
Formula for countifs and or from multiple columns
Hello, I am trying to count if {Goal #1} and {Goal #2} are not blank IF {Office Name} is [Primary Column]@row OR {Division Name] is [Primary Column]@row. The way my tracker sheet is set up is that I have Office Name & Division Name as separate columns and I need to count that each office or division has completed Goal #1…
-
Parent & Child Formulas in the Same Column?
My sheet is structured as a sort of tiered task checklist. There are several Parent rows with varying numbers of Child rows. There are two columns that are involved with my issue: the first is a "Status" column, and the second is a sort of "True/False" binary check labelled as "% Complete." There are no formulas in the…
-
Trying to find specific headcount for each month of arrivals and how to include End Date
Hello All, I have a formula currently counting the arrivals for a headcount but it is not counting who is staying past that month. How can I change my formula to accomodate not only new arrivals but also the current personnel that are there for future months. I.E. New arrivals + Current personnel =COUNTIFS({TA Management…
-
INDEX MATCH (Multiple Criteria) vs INDEX COLLECT
Hello Smartsheet Community, I have a metric sheet set up where I am pulling from a much larger budget sheet - on my metric sheet, I want to pull in the market and due dates based on the project description. Nearly all projects have a unique description and my INDEX MATCH function works without issue; however, there are a…
-
Count Collect formula crashing large sheet - Scheduling conflict identification
Hello, I am running a Count(Collect) on a sheet with 8000 records. The formula calculates for a small number of records but if I make it a column formula or copy it to every cell then the sheet crashes. Does anyone know how to count thousands of rows that meet certain conditions without crashing the sheet? Purpose of…
-
populate column based on parent rows
Hi All, Need some guidance is there way to automate column 20 to auto populate whatever the parent cell on task name? @Paul Newcome It's Maz Uddin, this is a new account. Please can you answer if you have time.
-
Using COUNTIFS with ranges of different size
COUNTIFS( range1, criterion1, [ range2, criterion2... ]) OK, I'm stuck. When using COUNTIFS, and both ranges only cover 1 column each, or both ranges cover multiple column, it works perfectly. But, when for example, range 1 covers only 1 column and range 2 covers more than 1 column, I get the following error message:…
-
Creating charts with multiple criteria without summary sheets and thousands of distinct formulas
I have a grid that contains an employee's level of expertise is a specific skill. There are 90 skills listed (columns) and around 50 employees. Each cell contains None, Beginner, Intermediate, or Expert. There are additional columns for each employee's name, department, and whether they are 'Active'. In order to create a…
