-
Wildcard workaround
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. Below if my code: =COUNTIFS({Papers Range 2}, "*O'Malley*", {Papers Range 3}, "1 - Published") How would I edit this to…
-
No Category Appearing on Calculated Column in Calendar App
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 in the report but shows as No Category on the calendar. Is there anyway to change this to 0? I've got a countif for…
-
Count formula help
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 iterations of formulas and continue to get errors. Would love your thoughts. =COUNTIF({Week #}:[Week #], ${Week #}:$[Week…
-
Distinct Count IF or Running Count Total
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 times Dealer Name is referenced. In my situation I would need "TriGreen Equipment - Ag & Turf" is referenced twice but has two…
-
COUNT IF - CRITERIA
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 "COUNTIF" formula to count them by using, the 22, 23 and 24 as criteria, to know how many items I have per year, however it…
-
How can I make COUNTIF into a column formula?
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 pops up when I try to convert it to a column formula: I just don't want to continue to drag the formula down with each…
-
How can I make COUNTIF into a column formula?
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 pops up when I try to convert it to a column formula: I like the current formula because it allows me to set up my Request…
-
Can I use Countif with multiple criteria in one cell
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 individual counts of those items to then be populated into the sheet below
-
Why is my countifs formula not working
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 incorrect argument error =COUNTIFS({Event Management Sheet Range 3}, [Column4]@row, {Event Management Sheet Range 7}, >DATE(2023,…
-
Countif with Dates
HI all, I'd like to ask your help. I am trying to count the number of items which are planned for particular dates, so the formula should be easy yet.. I get "0" which is incorrect. I need this for my metric to later use it for burn up chart. =COUNTIFS({W2 System Test Tracker Range 1}, [Column2]$2) the bit "W2 System Test…
