Countif
Discussion List
- Based on what I read about HAS Function in the Formula Basics (HAS Function | Smartsheet Learning Center) I should be able to use HAS with COUNTIFS. When I try to use it in a sheet, I receive the erro…
- Hi Smartsheet community. I have been working on a formula and it has not been working. Wondering if I am going about it the wrong way? I am working on a lessons learned project sheet where i am confir…
- Trying to count following: Any row on reference sheet in the YEAR column that is equal to "2025", CONTENT TYPE ="US" (dropdown column, single select), TEAM = "EU4" (dropdown column, single select), CR…
- 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…
- 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…
- 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 anyon…
- 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 n…
- 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…
- 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. Form…
- 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 …