-
Combining COUNTIFS formulas
Currently I have two COUNTIF formulas in two different cells, then I am using a 3rd cell to add them together. I am looking for a way to combine the formulas and have everything calculated in one cell. Both formulas are pulling data from different sheets. 1st formula: =COUNTIF({B2B Thermo Fisher Project List Range 1},…
-
Checkbox for Unique Item Name
Hello! I'm trying to create a formula for checking a box for only the first instance of a unique value in the column "ITEM NAME". IE it sees the first instance of "Event Case 1" and checks the box for only that row, and the remaining instances don't get checked. I tried using the AI tool but the formula it creates can't be…
-
=COUNTIFS Metrics across 2 different sheets
Hi All, I have a metrics sheet where 4 of the 5 listed items reference 1 sheet and the last 1 references another sheet. I keep getting #UNPARSEABLE error for the 5th item. Below is my formula if anyone can help me figure out what is wrong that would be great! =COUNTIFS({Sheet - Continuous Improvement Sheet}{Project…
-
IF/COUNT and IF/SUM/CHILDREN Formula Help
I have a sheet (See below). In the 'Sheet Needed' column I have a formula: =IF(P@row = 1, COUNT([Sheet Created?]@row, IF(P@row = 0, SUM(CHILDREN())))) This is working in the Child Rows, however I am not getting a total in the Parent Rows. What am I doing wrong? I know it is late at night and I am sure I am doing something…
-
Help with COUNT forumula for column with duplicate names.
Afternoon, I am creating a reporting dashboard to report employee stats. Each of the metrics on my dashboard is fed from a dashboard calculation sheet. Each of the sections in my dashboard calculation sheet references another sheet based on different criteria. In each of these sheets, i have a column with employee names…
-
COUNTIFS + AND Formula does not Equal the Filter Count
Good afternoon. I am having issues with the below formula equaling the filter within the sheet that we are pulling form. Please see the below and point me in the right direction to help fix this. Formula: Filter: BC/PO/BL | is one of | PO, BL, SSA, Lease, License, Other Non-Board Items Status | has none of | Awaiting CRF,…
-
Calculate Number of Deals on a Waitlist at a Given Time?
Hi, For context, a buyer and seller will approach my team and provide us with a proposed close date of their deal. Often times our deal teams are finishing up other deals and cannot immediately start working with them. We create a Salesforce opportunity and add them to our "Waitlist" (category in SF opp). Sometimes this…
-
How to count several non-blank rows based on specific criteria across two sheets
Hi Community! I have two different grid sheets within smarthseet with the following information: In sheet 1 I have several products that need a certain number of photography shots and being delivered in different channels. Each row has a due date. In sheet 2 I want to find a formula that would give me the numbers in blue.…
-
Why didn't my original CountIF formula work?
I am trying to count the number of projects that began since Jan 1, 2024. I typed in the formula =COUNTIF([Start Date]:[Start Date], ">= Jan 1, 2024"). Basically I wanted to count the number of projects with a start date that were equal to Jan 1, 2024 or greater. However that formula gave the blatantly incorrect answer.…
-
Counting Active Projects
Hey! I am wanting to count the number of projects in each department (e.g., Health Action) that are marked as active. I am currently using this formula where I manually enter how many inactive project to subtract from the total but I would like to have this imbedded in a formula so it updates automatically. Thank you!