Countif
Discussion List
- I have resource names (one per column on the destination sheet, and one per row in the source sheet), start dates for jobs (one per row in the source data sheet), and end dates (same) for the same job…
- Hi, Trying to get some counts for a report and have run into a bit of a road block. In excel, I would typical use a count formula and a wildcard. However, Smartsheet doesnt seem to have the capability…
- I have a report which feeds into the calendar app in which we track speaker utilisation. The data is grouped by speaker name and then their total utilisation. When utilisation is zero, it shows this i…
- I need to count number of tickets in a few columns, independently, and present the calculations in a metrics sheet to be used later. I need to calculate weekly and monthly numbers. I have tried many i…
- Good Morning All, I need a formula to count the running total of the Dealer Names as they appear. The current formula I have in Column 14: =COUNTIFS(Dealer:Dealer, Dealer@row) is showing the total tim…
- Hello Team, I have the following data to work on: 22-123 22-456 22-789 23-123 23-456 23-789 24-123 24-456 24-789 Where the first 22-, 23- and 24- represent 2022, 2023, 2024. I'm trying to use the "COU…
- I have been using a COUNTIF formula that I am unable to convert to a column formula. Is there a way that I can alter it so it can be a column formula. This is what I have: And this is the message that…
- I have been using a COUNTIF formula that I am unable to convert to a column formula. Is there a way that I can alter it so it can be a column formula? This is what I have: And this is the message that…
- Hello would it be possible to use the Countif statement when there are multiple items in a cell. See below for further information Here is the column that has multiple items in each Cell I need to get…
- This works =COUNTIFS({Event Management Sheet Range 3}, [Column4]@row, {Event Management Sheet Range 7}, >DATE(2023, 9, 30), {Event Management Sheet Range 7}, <DATE(2024, 10, 1) But this gives an incor…