-
Visualize categorized count data
Hi Y'All, I have a small task that I do not know how to solve. We collect project data and one specific info we are counting and, I would love to visualize is: How many contracts were signed in year xx and quarter y? As background, my data structure consists of 1 project per row. A column is a manual input called "signed…
-
How do we get one or more checked check boxes, checked value in one cell? I need to get checked %
-
Countifs w/ not contain function referencing another spreadsheed
I have column (status) that has multiple valid options that I want to count but i"m referencing a separate sheet (using a project rollup method given we don't have pivot app) what is the syntax for this ? =COUNTIFS({project Range 2}, "TMS", NOT(CONTAINS{"Closed", "Complete", Project plan Range 4}
-
Countif in last 3 months
Hi, I need to count if certain data is used in 6 different columns. Here is what I have so far: =COUNTIF({Test Range 1}, [Name]@row) + COUNTIF({Test Range 2}, [Name]@row) + COUNTIF({Test Range 3}, [Name]@row) + COUNTIF({Test Range 4}, [Name]@row) + COUNTIF({Test Range 5}, [Name]@row) + COUNTIF({Test Range 6}, [Name]@row)…
-
Using COUNTIF Formula
Hello, I am trying to calculate the number of times a certain type of request come through on a form in instances where multiple options can appear in the one cell. I've tried manipulating the formula several ways, but it still is not calculating correctly. Can you help me figure out what I'm doing wrong? The 2 formulas…
-
Trying to count if data range falls between two dates.
I have a sheet with StartDate and EndDate fields. I want to count actual items opened on a separate sheet if the date falls between the start date and end date. The below formula keeps returning #UNPARSEABLE and I suspect its something minor. =COUNTIFS({Request Tracker with Form Range 1}, "<=" & (EndDate@row),{Request…
-
Countif- Remove Duplicates
Hi there! I am trying to count the type of client we have per opportunity attached to a project. We will have some projects attached to the same opportunity and we will not want that data to be counted twice. I have attached a sample sheet of the data. I have been using this formula to count duplicates. However this is…
-
Capacity formula
I am trying to add to this formula "<+" &{end week}, Weekend@row =COUNTIFS({Name}, [Primary Column]@row, {Week}, start@row, {Year}, [Column3]@row, {SKill}, "LTE") * 60 I want this formula to look and see the end week and add 60 for every week of the project. Help columns and example below. Right now this formula tracks 60…
-
Formula help: Count how many dates are from the last week and the coming week
I am trying to do an equation in sheet summary that will calculate how many dates were in the last 7 days and are scheduled in the next 7 days. This is what I have, I've tried others on community questions that were close and figured I would just ask. =COUNTIFS([Start Date]:[Start Date], @cell <= TODAY(-1), @cell >…
-
How do I see if a resource has (or is) working a specific date?
I have resource names (one per column on the destination sheet, and one per row in the source sheet), start dates for jobs (one per row in the source data sheet), and end dates (same) for the same jobs. I'm trying to use an equation to see if the resource is working every date, throughout the year (one date per row, in the…
