-
Countifs function to count ratings by location within the past 7 days
I am trying to create a countifs function to count 5-star ratings by restaurant location published within the past 7 days. The published column contains dates. So far, I have this equation: =COUNTIFS(Rating:Rating, =5, Location:Location, "Bayshore", Published:Published,AND(@cell <= TODAY(), @cell > TODAY(-7)) I am getting…
-
#INVALID DATA TYPE when using COUNTIF Formula
Hey Community - I am having an issue trying to use the COUNTIF formula. In this use case, I basically have a formula in the first column to show if start and end dates match with other columns in the sheet. All I want to do is count the number of "Yes" cells, but when I try to use the COUNTIF formula, I get an #INVALID…
-
countifs + find formula with multiple criteria
Hello, I'm fairly new to smartsheets and trying to solve a roadblock. I'm trying to count the amount of times a specific string is in a cell with two types of status: closed and submitted. I'm using the FIND because some cells contain more than one ticket # (i.e. "Ticket-432, Ticket 12435") =COUNTIFS({Database Range 1},…
-
Count of All Items, where Start Date is less than Today
Hi, I am trying to get a count of all Task Named: "To Do", where "Start Date" is less than Today's date. I am using: COUNTIFS(Task Name, "To Do", StartDate, "StartDate < Today()"), for this, I keep getting '0', but I see there are at least 4 tasks meeting this criteria. Any help if very much appreciated. Thank you, Deepthi
-
Count all cells in a column that are NOT blank and do NOT contain a date
Hi, I want to create a formula in a date column that allows me to count all of the cells in the column that are not blank but do not contain a date. I have tried various COUNTIFS but can not seem to find the perfect solution. Thank you for your assistance.
-
Flagging task if not updated
Hi, I have a sheet that tracks a group of teams' weekly KPI's. Each week on a Thursday, the different team members need to access their sheet, update the date that their KPI's relate to and enter the KPI's for each line. Each team has a separate sheet that rolls up into a "AT RISK" task tracking report for me. I have to…
-
Counting a date diffrence with children
Hello, Does anybody know if there is there a way to make the below formula work? I'm not sure what I'm missing. I need a count of children where the difference between the task due date and the created date is 1 or less.This one has stumped me. =COUNTIF(SUM(CHILDREN([Due Date]8) - CHILDREN(Created8)), <=1)
-
Countif referencing another sheet not working
I have a column in another sheet called Ranking (Text/Number field). It contains numbers from 1-200. Using this formula it's returning a value of 0 which is not accurate from the column I selected. Is there something I'm missing? =COUNTIF({Ranking}, >100) I even tried to complete the formula in the sheet directly and it's…
-
Help index and match?
Hi: I have a sheet (target) which has a project ID. I have another sheet (source) with 100 columns (which has the project id) I want In the target to take about 20 fields from the source and put into the target. Vlookup is limited as it can't handle more than 20 columns. and I can't find an example MY field is called…
-
Some Results are not showing from my formula
=IFERROR(SUMIFS({# tags}, {TaggedBy}, Employee1, {QAedCebu}, MONTH(@cell) = 10), " ") Formula Breakdown: (Reference Sheet A contains all tags, dates and employee assignments, Sheet B is the sheet I am trying to create totals on) # tags = Number Column (ref to sheet A column) TaggedBy = Employee Name Column (ref to sheet A…
