Countif
Discussion List
- I am creating Dashboard Metrics based on Status information in a sheet. The sheet has a Status Column, Parent Status Column and a helper Column "Parent" that is Zero if it has children records or if i…
- Hi, I am looking for a formula that counts that instances that a particular department was listed. In my scenario, Person 1 & Person 2 belong to the same department. Current formula I am using is Atte…
- Hi all - I am creating a calculation sheet that reference a ticket intake smart sheet. I want to use this calculation sheet to count based on the country that submitted it and what the status of the t…
- Hi! I keep receiving the "unparsable" error when trying to Count from Children (sub rows) for a specific year. Current formula entering is =COUNT(CHILDREN([Alliance Partner(s)]@row), ([AM/PM Years Act…
- Hello - Hoping for some help on my formula below. I am trying to count the number of dates (at a specific location) that are between 30 and 60 days from today. Here is my current formula: =COUNTIFS({B…
- Dear Smartsheet Community, I'm observing a strange problem and not sure whether it's because I'm doing something wrong: I've used the COUNTIF function many times to count the number of checked checkbo…
- I am using the formula below and the NOT CONTAIN is not working. Could anyone help? COUNTIFS({Spreadsheet_1 Range 3}, "John Smith", {Spreadsheet_1 Range 1}, "In Progress", {2023 Spreadsheet_1 Range 2}…
- I am trying to find if there are multiple requests for a bucket truck within a single day. I am getting an incorrect argument set when I try this formula, but I cannot figure out what is wrong with it…
- Hello, I have a formula set to count how many projects are flagged within a specific function if they are listed as in progress, but the count is off and I can't figure out why it's not counting all i…
- Hello I am looking for assistance with a formula as I need to count across multiple sheets. I am trying to capture the number of times a word appears. I selected the columns in which the word appears …