Need help with syntax for a formula for counts. Goal: Give a count where If STATUS field contains string value "new" and where a checkbox named External is checked. Formula: =COUNTIFS(Status:Status, "…
I am trying to create a count of how many rows in my sheet meet a certain criteria. I created a Sheet summary field and used the COUNTIF Formula. However, it keeps returning #NO MATCH when there clear…
I'm curious to see if there is a formula out there that I am missing. Currently this formula takes this current year and subtract one from it and also references a month based on a monthly column. So …
I have a count of incidents for each location. The "rank helper" column use to total the number of incidents beside the first occurrence of a name. For example: Bellflower has "2" incidents. I want th…
Hi, thought I could use some variation of =COUNT(DISTINCT(COLLECT({Advisor Rep ID}, IF{Client for the rep id is not equal to any of their other on the sheet}, WHERE {Case Consultation Meeting Number},…
I have countifs statement but then need to account for multi-value dropdown list and wonder the best way to capture the values. So counting projects status of in project - with a business value of 6 o…
Hi i am trying to perform a distinct count of account name, based on a text string lookup conditional on the progress/stage of the client. i have tried using the HAS formula as this worked previously …
=COUNTIFS({Created}, >=DATE(2024, 1, 1), {Physician Process SOAR 1.0 Range 1}, [Visit Type 2024]@row, {Physician Process SOAR CFT NAME}, CONTAINS("Boomer, Mark", @cell)) Hello all, Need group think/he…
Hi all! Looking for some expertise with COUNTIFS, HAS, and CONTAINS formulas when also using reference sheets with dropdowns. I have one reference sheet that my team is using to track employee's learn…
I am trying to do a sheet summary formula to get the percent of tasked closed assuming Project Name is "RPA Project" Please see formula: =IF([Project Name]:[Project Name] = "RPA Project", (Closed# / […