Countif
Discussion List
- 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 …
- 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 projec…
- 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…
- I'm trying to create an attendance tracking sheet, and different numbers of absences leads to different diciplinary measures. I know I could use COUNTIF, but there will be hundreds of employees, and I…
- Hi, I am trying to count the amount of time a drop down is selected within a range of columns that is in a specific location (separate column with it's own values). My goal is to count how many times …
- I need a formula that counts the number of requests that have been submitted within the last seven days if assigned to "John Doe". Smartsheet's AI generated this formula, however it comes back to me a…
- Hello All! Need a little help- I have a formula where I need to reference another sheet and then count based on two criteria. Right now I am getting and error would love another perspective. The formu…
- I am trying to get this formula to work, but it kicks back the nested criteria. =JOIN(DISTINCT(COLLECT([Employee Number]:[Employee Number], [Created Date]:[Created Date], IFERROR(MONTH(@cell ), 0) = M…
- Hi, I am attempting to create a formula that would = Count the number of training items completed per team member and between two dates. I created this formula, it is giving me all Zeros: =COUNTIFS([A…
- Hi! I am currently building a dashboard to show reporting on employee injuries for cases that are not resolved. I am having trouble with my formula and have been spinning my wheels. I need the formula…