-
Counting number of events (lines) within a time range
Hi, I looked at the past discussion but didn't find the answer. My sheet has a row for each events happening with the precise dates (ex: 8-Aug-2024). I would like to count any event that happened within a time frame (march 1rst to march 31rst of the next year). I tried various formulas but no luck at all…
-
Counting Text Color
Hello, I am working on creating metrics in our Smartsheet milestones. Currently, if a milestone was completed on-time, the date completed is turned green. If the milestone was not completed on-time, the date completed is turned red. What I would like to do is create a formula for metrics that reads the text color for how…
-
Countifs formula Error
Hi, I have one main sheet and i'm going to pull data from that to another sheet, in this case i need to count my new Client Details within the particular date range, the problem is Project name details is repeating in the colounm (Single project has multiple products so i've kept seperate entry for all the products due to…
-
How do I COUNT items according to the criteria of Date and Category?
I am try to create a metric to understand how many items were shipped in a month, according to the product type. Can some one help with the formula from the example below? https://us.v-cdn.net/6031209/uploads/VLO3LPVF0HVC/kpis-for-smartsheet-metrics.xlsx
-
Count Past Due Task and Exclude Status that is Complete
I am trying to count past due tasks but exclude any tasks that are past the End Date. Below is my current logic that is NOT working. =COUNTIFS({P904 - Walkthrough Past Due}, AND(@cell < TODAY (), AND(@Cell <> "Complete" ))) Below is logic that is counting all items that are past the End Date =COUNTIFS({P904 - Walkthrough…
-
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…