-
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…
-
COUNTIFS with multiple inputs and dates
I'm trying include a date range with counting the number of applicants within various depts, in certain date ranges, but it's saying incorrect argument set. =COUNTIFS(DISTINCT([Name of Requestor]:[Name of Requestor], [Submission Date]:[Submission Date], AND(@cell > DATE (2023, 9, 30), @cell <= DATE(2023, 12, 31))))…
-
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…
-
COUNTIFS with multiple criteria
Hello, I'm having issues with smarthsheet recognizing my columns names. Any thoughts? When I write the Status:Status piece, it does make them active to that column, but as soon as I get to the Submission Date:Submission date portion, it removes the coloring/linking. I've also tried Submission Date:Submission Date with &…
-
Creating a widget for tracking the tasks for each member of a team
Hi. For the past few days, I've been trying to create a dashboard to track the tasks that each member of my team has. I learned that the best way to do this is to create a separate sheet where I used formulas to create a set of data and then use those to create charts in my dashboard. However, when I tried to use a formula…
-
COUNTIFS always returns 0
I can't get my COUNTIFS equation to work, it always just returns 0, can anybody help? =COUNTIFS([Column A]@row, "None", [Column B]@row, "None", [Column C]@row, "None", [Column D]@row, "None", [Column E]@row, "None", [Column F]@row, "None")
-
Counting multiple items in a single dropdown list
I'm tracking evaluations completed per month and in mydropdown list I have selections including: "Personal delivery" "Email" "Personal deliveryx2" (recently added) "Email x2"(recently added) Ona helper page, I was using a countif formula to count "personaldeliveries" only. But now that I want to count "personaldeliveries"…
-
Formula for Counting Parent Rows based on a specific column criteria
I need a Countif formula to count the number parent rows that have a specific column value of > 37 , and another formula to count the number of parent rows with the same specific columns value of ,+ 37. Can this be done in the Sheet Summary? The issue is I have Children rows beneath a few Parent rows and I don't want those…
-
Having Formula Troubles
Hello, I am trying to count a certain number of product types within a certain work week, both referenced in other sheets. I am able to count my work week data for all product types in one column using =COUNTIFS({Calculation - Defect Rate Run Chart Range 1}, =[Work Week]@row) I have another cell that I am trying to grab…
-
Which formula do I need if I want to count issues assigned to 2 people that are counted for each ind
Hi everyone, I am fairly new to Smartsheet and this is my first question in this community! I have an Issue Tracker where issues can be assigned to multiple people. On one of the charts on my dashboard I am showing how many Issues are assigned to each individual. I have a formula that counts if an issue is assigned to 1…
