countifs - Robuta Search

https://community.smartsheet.com/discussion/97244/sumifs-countifs-date-issue SUMIFS/COUNTIFS Date Issue - Smartsheet Community Hi all, I am attempting to create a formula to add up all the Employees from a sheet from last month. This sheet is pulling in totals on an automation monthly.... sumifs countifs date issue smartsheet https://community.smartsheet.com/discussion/50641/using-countifs-with-find-and Using COUNTIFs with FIND & AND - Smartsheet Community Hi, I need to add up the following: 1) All Labeled as Country X from a Qualitative field that is requiring me to use the FIND function. 2) All labeled as AreaY... using countifs find smartsheet community https://community.smartsheet.com/discussion/47416/countifs-for-one-date-greater-than-another-within-a-given-period CountIfs for One Date Greater Than Another Within a Given Period - Smartsheet Community Hi there! I'm trying to get a total of projects projected to start between two dates that actually started after their projected start date. This is the... https://community.smartsheet.com/discussion/26096/countifs-formula COUNTIFS Formula - Smartsheet Community Hello Community, I am encountering difficulty in using COUNTIFS formula to count the items with active dates within the quarter of the year. I tried the below... countifs formula smartsheet community https://community.smartsheet.com/discussion/92541/using-countifs-for-multiple-criteria Using countifs for multiple criteria - Smartsheet Community multiple criteria using countifs smartsheet community https://techcommunity.microsoft.com/discussions/excelgeneral/trouble-using-worksheetfunction-sum-and-countifs-together/4226091/replies/4226117 Trouble using WorksheetFunction SUM and COUNTIFS together | Microsoft Community Hub I'm trying to write a small vba where I need to check two conditions and if they the conditions are met add total the number of records that meet the... microsoft community trouble using worksheetfunction sum https://techcommunity.microsoft.com/discussions/excelgeneral/countifs-returning-a-value-used-in-this-formula-is-of-wrong-data-type/3720690 CountIfs returning "A value used in this formula is of wrong data type" | Microsoft Community Hub https://community.smartsheet.com/discussion/50726/countifs-with-reference-to-another-sheet-more-than-one-criterion COUNTIFS with reference to another sheet more than one criterion - Smartsheet Community more than one https://techcommunity.microsoft.com/discussions/excelgeneral/countifs--create-columns-for-each-attribute-with-datatype-10/353659/replies/353889 Countifs / create columns for each attribute with datatype 1/0 | Microsoft Community Hub Hey guys,I am not sure if the subject ist understandable...I hope you can help with my topic. I never heard from COUNTIFs before, but heard that my "problem"... https://community.smartsheet.com/discussion/65091/countifs COUNTIFS - Smartsheet Community I am trying to count number of lines from project master list that are in a certain region and when the Forecast $ is greater than the Actual $. Looking for... countifs smartsheet community https://community.smartsheet.com/discussion/132323/countifs-metrics-across-2-different-sheets =COUNTIFS Metrics across 2 different sheets - Smartsheet Community 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... countifs metrics across different sheets https://community.smartsheet.com/discussion/43706/countifs-same-column-different-criteria Countifs same column different criteria - Smartsheet Community Hi I'm trying to count the items in the in one column if they are not equal to criteria in another column. May someone assist. This is what I have so far.... countifs column different criteria smartsheet https://community.smartsheet.com/discussion/112799/utilizing-the-countifs-and-has-for-a-dropdown-list-column Utilizing the "COUNTIFS" and "HAS" for a dropdown list column - Smartsheet Community for a https://community.smartsheet.com/discussion/101209/using-column-formulas-for-countifs-sumifs-evaluation-arent-working Using Column Formulas for CountIfs / SumIfs evaluation aren't working - Smartsheet Community I have a sheet for Test Scripts. In this sheet we have an AutoNumber column so we have a fixed ID. We also have a calculated column with the ID and the Name.... https://community.smartsheet.com/discussion/105382/formula-countifs-mulitiple-criterion Formula countifs mulitiple criterion? - Smartsheet Community formula countifs criterion smartsheet community https://community.smartsheet.com/discussion/109433/countifs-and-sum-in-same-column Countifs and Sum in same column - Smartsheet Community I am trying you count checkmarks in individual columns and total up at the bottom for a score on a specific project(column) and then region (multiple columns).... countifs sum column smartsheet community https://community.smartsheet.com/discussion/85848/using-contact-on-a-multi-contact-column-as-condition-for-countifs Using contact on a multi-contact column as condition for countifs. - Smartsheet Community I have the following formula. The range is a multi-contact column. There may be a single contact or several. The Contact8 references another cell with a single... on a multi column https://community.smartsheet.com/discussion/82372/countifs-for-smartsheet-excel-formula-translation-to-smartsheet CountIFS for smartsheet (Excel formula translation to smartsheet) - Smartsheet Community excel formula countifs smartsheet translation community https://community.smartsheet.com/discussion/93492/countifs-and-check-boxes COUNTIFS AND CHECK BOXES - Smartsheet Community I tried to go through different scenarios and look to see if this has been asked before but wasn't able to find it. I am count 2 different columns. The first... check boxes countifs smartsheet community https://techcommunity.microsoft.com/discussions/excelgeneral/countifs-help/3730238/replies/3730332 Countifs Help | Microsoft Community Hub Hello all. Thank you in advance. This may be a duplicate post, I just cannot find the original. I am trying to use the COUNTIFS... microsoft community countifs help hub https://community.smartsheet.com/discussion/61726/countifs-for-dates COUNTIFs for Dates - Smartsheet Community I'd like to create a formula which only counts the Rows in which a date in a particular column is in the last 30 days (among other criteria)... countifs dates smartsheet community https://community.smartsheet.com/discussion/139039/countifs countifs - Smartsheet Community I have a sheet A with Client name and status, I have a sheet B with the data, I want to search every row of sheet B for the client and status of completed live... countifs smartsheet community https://community.smartsheet.com/discussion/95368/solved-invalid-value-with-countifs-formula SOLVED Invalid Value with COUNTIFS Formula - Smartsheet Community SOLVED: there were a few invalid values in there causing the counts to not work properly. Lesson learned Hi, I have a COUNTIFS formula that works just fine... solved invalid value countifs formula https://community.smartsheet.com/discussion/77115/how-to-countifs-when-cell-is-blank-and-not-today How to COUNTIFS when cell is blank and not today. - Smartsheet Community I need to know how to return a value by these parameters. * There is a column named Completion Date. If it is blank, I need it counted. * I need it to look at... how to https://community.smartsheet.com/discussion/121200/countifs-function-with-an-or-function-included COUNTIFS Function with an "Or" function included? - Smartsheet Community Hi all. I am currently trying to create a COUNTIF function that has 2 required parameters, and then 4 "or" parameters. Basically, the formula should count if... with an countifs function included smartsheet https://community.smartsheet.com/discussion/118044/summing-multiple-countifs-statements Summing multiple countifs statements? - Smartsheet Community I'm trying to track how many days an item was out of stock over a rolling period of time. The formula I am currently using is below. The issue I'm running into... summing multiple countifs statements smartsheet https://community.smartsheet.com/discussion/121637/need-help-on-countifs-formula Need help on countifs formula - Smartsheet Community need help countifs formula smartsheet community https://community.smartsheet.com/discussion/109368/countifs-referencing-multiple-columns-one-of-which-is-multi-select CountIFs referencing multiple columns, one of which is multi-select - Smartsheet Community I am trying to do COUNTIFS with multiple criteria/columns, referencing another sheet. Essentially, I need a Count of if the items meet the following criteria:... multiple columns one of https://community.smartsheet.com/discussion/77452/countifs-with-two-not-contains-for-the-same-column COUNTIFS with Two NOT CONTAINS for the same Column - Smartsheet Community I need a formula to return the count of the number of rows where my Receipt # column is not blank, and where the Notes column does not contain insufficient... for the countifs two contains https://community.smartsheet.com/discussion/98372/countif-or-countifs Countif or countifs - Smartsheet Community I have a column Titled Expiration date. I would like to count all the dates in this column if the date is before today's date. I was googling around and found... countif smartsheet community https://community.smartsheet.com/discussion/86298/countifs-date-range-in-date-column-with-blanks COUNTIFS date range in Date Column with blanks - Smartsheet Community Hi, I have a date column with blanks that I'm trying to get a count of cells that contain dates by quarter (Jan-March, April-June etc.) I tried this:... date range countifs column blanks smartsheet https://techcommunity.microsoft.com/discussions/excelgeneral/refering-to-a-date-within-another-cell-when-using-the-countifs-formula/72737/replies/72739 Refering to a date within another cell when using the COUNTIFS formula | Microsoft Community Hub https://community.smartsheet.com/discussion/95060/how-to-add-new-criteria-to-my-current-countifs-formula How to add new criteria to my current COUNTIFS formula? - Smartsheet Community Hi all! Not sure how to add the criteria do not add to count if cell = "Topic" to my current COUNTIFS formula. Current foluma is:... how to add new criteria https://community.smartsheet.com/discussion/120132/countifs-formula-always-return-o-as-a-value COUNTIFS formula always return O as a value - Smartsheet Community I have use several times the COUNTIFS formula and it was working fine with dropdown list using text, seems to be a issue when the dropdown list use symbols... as a countifs formula always return https://techcommunity.microsoft.com/discussions/excelgeneral/use-countifs-and-indexmatch-to-pull-data-from-another-table/4193464/replies/4193478 Use COUNTIFS and INDEX/MATCH to pull data from another table | Microsoft Community Hub Hi. I have two tables, one with information (Attendance Sheet) and one where I need to pull information into (Info sheet). I have attached screenshots... https://community.smartsheet.com/discussion/128978/countifs-issue COUNTIFS issue - Smartsheet Community I am pulling data from another sheet in SmartSheets using the COUNTIFS function. I want to count all the times the words "Parish Center" is used in the other... countifs issue smartsheet community https://community.smartsheet.com/discussion/83398/countifs-if-a-date-cell-is-within-30-days COUNTIFS if a Date cell is within 30 Days - Smartsheet Community Hi, Is it possible to COUNTIFS with one of the criteria being a date that is equal to or within 30 days to that set in another cell? In the past I have used a... a date countifs cell https://community.smartsheet.com/discussion/96206/hi-can-someone-help-me-with-using-row-within-my-countifs-formula Hi, Can someone help me with using @row within my COUNTIFS formula? - Smartsheet Community https://community.smartsheet.com/discussion/118349/how-to-get-countifs-to-include-selection-within-a-dropdown-list-of-multiple-values-per-cell How to get COUNTIFS to include selection within a "Dropdown List" of multiple values per cell. -... Hi Smartsheet Support Community! I monitor the marketing and communications request for support log for our organization. We currently use one column to inform... https://community.smartsheet.com/discussion/138962/countif-countifs-formula-help COUNTIF/COUNTIFS Formula Help - Smartsheet Community Good Day! I have an intake sheet, that I want to use to create a Summary so I can add graphs to my Dashboard. I'm looking for a formula that will show how many... countif formula help smartsheet community https://community.smartsheet.com/discussion/89013/using-countifs-with-or-function-spread-across-multiple-ranges Using COUNTIFS with OR function spread across multiple ranges - Smartsheet Community Hello, I am trying to build a COUNTIF function that will count all cells which meet criteria 1 and either criteria 2 or 3, which are found in different ranges.... using countifs function https://community.smartsheet.com/discussion/83859/countifs-with-multiple-criteria COUNTIFS with multiple criteria - Smartsheet Community I need help with creating a formula where there are several criteria based off two different things. My columns are "Received from LO" needs to be yes and... multiple criteria countifs smartsheet community https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Averageifs-and-Countifs-in-Power-Bi/m-p/2726454 Solved: Re: Averageifs and Countifs in Power Bi - Microsoft Fabric Community Aug 25, 2022 - Create a measure like Avg Measure = AVERAGE ( 'BV37CC'[CONTRIBUTION COST]) and use that in conjunction with the calculation group. Be careful with power bi microsoft fabric solved averageifs countifs https://community.fabric.microsoft.com/t5/Desktop/Countifs-to-identify-duplicates-in-dataset/td-p/4134644 Solved: Countifs to identify duplicates in dataset - Microsoft Fabric Community Sep 8, 2024 - Solved: Hi, I have the purchase register of a company and I'm trying to identify and present duplicate entries in it using power bi. In excel i microsoft fabric solved countifs identify duplicates https://community.smartsheet.com/discussion/103702/help-cannot-get-countifs-formula-to-work Help! Cannot get COUNTIFS formula to work - Smartsheet Community @Paul Newcome I am trying to count the number of occurrences of the "Deliverable Type" with a quarterly date range (i.e., January to March, April-June,... to work help cannot get countifs https://community.smartsheet.com/discussion/30861/issue-with-countifs-or Issue with CountIFS OR - Smartsheet Community Hi all, I am running into some trouble iterating on this formula which was a countifs with an "AND." I am now trying to add an "OR" to the first part. I want... issue countifs smartsheet community https://community.smartsheet.com/discussion/76808/countifs-formula-to-count-a-value-within-a-date-range Countifs formula to count a value within a date range? - Smartsheet Community Our company has ongoing surveys and the raw data is organized by different dates (dates the survey was complete). We want to only count the cells for a... date range countifs formula https://community.smartsheet.com/discussion/49331/countifs-function COUNTIFS function - Smartsheet Community I have two columns that I am using, one is a checkbox column, the other is a date column. I want to know, of those that have a checkbox checked in one column,... countifs function smartsheet community https://techcommunity.microsoft.com/discussions/excelgeneral/countifs-by-month-excluding-year/3673930 COUNTIFS by Month Excluding Year | Microsoft Community Hub I'm attempting to do a COUNTIFS function based on a date range but want to exclude the year so that the date can be updated easily from one year to the next... by month microsoft community countifs excluding year https://community.smartsheet.com/discussion/55631/countifs-with-and-or Countifs with AND/OR - Smartsheet Community Hi There I have a Countifs that is counting the number of projects that are healthy (Green), marked as "prioritized", are "in progress" and match a particular... countifs smartsheet community https://community.smartsheet.com/discussion/78927/countifs-with-multiple-criteria-not-equal-to countifs with multiple criteria NOT equal to - Smartsheet Community multiple criteria not equal countifs smartsheet community https://community.smartsheet.com/discussion/89905/countifs-with-greater-than-or-equal-to-and-less-than-or-equal-to-date-range COUNTIFS with greater than or equal to and less than or equal to date range - Smartsheet Community Hi, I'm trying to run a COUNTIFS on a Smartsheet that has a "Created Date" when a user submits a form. I want to count the number of submissions within a given... https://community.smartsheet.com/discussion/134831/hi-there-i-want-to-find-out-how-to-use-countifs-using-3-criterion Hi there. I want to find out how to use COUNTIFS using 3 criterion: - Smartsheet Community Hi there. I want to find out how to use COUNTIFS using 3 criterion: How many "Complete" tasks have been done in the month of "January 2025" for the workstream... i want to find https://community.smartsheet.com/discussion/72884/countifs-or-function-error/p1 COUNTIFS OR Function Error - Smartsheet Community Hi, I'm attempting to create a formula that will count the number of requests that are pending review. The column uses a drop down menu with three options,... countifs function error smartsheet community https://community.smartsheet.com/discussion/98320/countifs-query-please-help Countifs query - Please help - Smartsheet Community I am trying to count the number of items set on a specific criteria, in this case I want to identify how opportunities I have at each stage within a give date... please help countifs query smartsheet community https://community.smartsheet.com/discussion/72942/countifs-formula-for-tasks-due-between-8-and-14-days-in-future COUNTIFS formula for tasks due between 8 and 14 days in future - Smartsheet Community I'm trying to write a formula to count the number of tasks due between 8 and 14 days in the future. I started with a formula that is working for the number of... https://community.smartsheet.com/discussion/112907/countifs-formula-not-getting-the-desired-result COUNTIFS Formula: Not getting the desired result - Smartsheet Community Hi there My COUNTIFS formula is not calculating what I want, correctly. We have x5 items that are past their delivery date. x3 Of the items are in the... desired result countifs formula getting smartsheet https://community.smartsheet.com/discussion/139455/getting-invalid-operation-using-countifs-with-two-fields Getting Invalid Operation using Countifs with two fields - Smartsheet Community I am trying to get a count of the number of rows that have a status of Task Assist, and who have an overall percent complete value of 100%. This is the formula... getting invalid operation using countifs https://community.smartsheet.com/discussion/89054/countifs-check-box-is-blank-between-dates Countifs check box is blank between dates - Smartsheet Community check box countifs blank dates smartsheet https://community.smartsheet.com/discussion/104303/countifs-w-multiple-criteria-date-present-phrase-inclusion-across-2-ranges-in-same-sheet COUNTIFS w/ multiple criteria (date present & phrase inclusion) across 2 ranges in same sheet -... I am a relatively new user, and I'm struggling with the creation of a COUNTIFS formula that checks one range/column to determine if a particular phrase is... https://community.smartsheet.com/discussion/102971/countifs-with-multiple-criteria-and-a-combo-criteria Countifs with multiple criteria and a "combo" criteria - Smartsheet Community multiple criteria countifs combo smartsheet community https://community.smartsheet.com/discussion/132399/countifs-contains-cross-sheets COUNTIFS & CONTAINS (cross sheets) - Smartsheet Community 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 =... countifs contains cross sheets smartsheet https://community.smartsheet.com/discussion/33871/countifs-by-month Countifs by Month - Smartsheet Community by month countifs smartsheet community https://community.smartsheet.com/discussion/46771/countifs-using-iferror-or-iserror Countifs using iferror or iserror - Smartsheet Community Hello, I'm trying to use a COUNTIFS formula to count the number of VLOOKUP errors in another sheet that occur in the past month. From what I can see in other... countifs using iferror iserror smartsheet https://techcommunity.microsoft.com/discussions/excelgeneral/wildcard-characters-not-working-in-countifs-function/4135730 Wildcard characters not working in COUNTIFS function | Microsoft Community Hub Hi y'all,this was a real brain scratcher for me, I gave up and went to the internet looking for answers. Here's my situation:I have two columns. Column 1 has... not working microsoft community wildcard characters countifs https://community.smartsheet.com/discussion/92332/countifs-formula-question COUNTIFS Formula Question - Smartsheet Community Hello, I am trying to use the COUNTIFS formula to capture the status of a project between a date range, and I am not able to figure it out. The formula I have... countifs formula question smartsheet community https://techcommunity.microsoft.com/discussions/excelgeneral/countifs-returns-value-each-of-the-criteria-works-in-its-countif-reason-compare-/4213481/replies/4213500 COUNTIFS returns #VALUE!. Each of the criteria works in its countif. Reason: compare span 2 cols. |... Hi: I have a COUNTIFS return #VALUE! when each of the 2 criteria would work in a COUNTIF on its own.So, =COUNTIF($B$6:$C$33,"Apple") and... https://community.smartsheet.com/discussion/55771/invalid-data-type-adding-month-to-countifs-with-cross-sheet-refs #INVALID DATA TYPE adding MONTH to COUNTIFS with cross-sheet refs - Smartsheet Community https://community.smartsheet.com/discussion/7746/countifs-with-a-date-range-and-symbols COUNTIFS with a date range and symbols - Smartsheet Community This is probably a no brainer for some of you with a lot more experience so I apologize ahead of time. For argument's sake, I have 2 columns. Column 1 we'll... with a date range countifs symbols smartsheet https://community.smartsheet.com/discussion/94758/ifs-countifs-match-no-match IFS & COUNTIFS/ MATCH, NO MATCH - Smartsheet Community Below is a screenshot of my sheet. I have count if, Match referencing another sheet with this sheet. Individual columns will show " MATCH"- ( DATE MATCH TEST... ifs match smartsheet community https://community.smartsheet.com/discussion/123202/my-countifs-statement-now-working My countifs statement now working - Smartsheet Community I am receiving an #INVALID DATE TYPE for the following countifs statement: My year column is a formula for =year on the Request Date. I have used this in... countifs statement working smartsheet community https://community.smartsheet.com/discussion/65293/countifs-based-on-children-criteria-of-certain-row COUNTIFS based on Children criteria of certain row - Smartsheet Community Context: Please see screenshot attached. Project Manager "Fred" has 2 "active" projects in January: Project 1 and Project 2, which are Children under "Fred".... based on countifs children criteria certain https://community.smartsheet.com/discussion/88891/reference-sheet-countifs-formula Reference Sheet CountIfs Formula - Smartsheet Community Hi I need help in doing a count ifs in another sheet. My countifs formula currently works in the summary section of the sheet but when doing a sheet reference... reference sheet countifs formula smartsheet community https://community.smartsheet.com/discussion/89669/combine-countifs-and-or-formulas Combine Countifs and OR formulas - Smartsheet Community I need to get a count of coworkers taking PTO on a specific week. My current sheet counts the week number PTO starts and ends (separate column for each). Is it... combine countifs formulas smartsheet community https://community.smartsheet.com/discussion/107627/countifs-question-stumped COUNTIFS question, stumped - Smartsheet Community I'm trying to count how many "Yes" is in the column (options are Yes and No). The column name is "Do you plan to stay overnight May 1st?" I feel like this is... countifs question stumped smartsheet community https://community.smartsheet.com/discussion/118546/countifs-error COUNTIFS error - Smartsheet Community So, a simple formula (that worked before), is now not working: =COUNTIFS([Approved 2024 $$]:[Approved 2024 $$], "", [Targeted Area]:[Targeted Area], "Atopic... countifs error smartsheet community https://community.smartsheet.com/discussion/82450/countifs-not-working COUNTIFS not working - Smartsheet Community Hello, I have attempted to COUNTIFS from one smartsheet to another, however I have had no luck. Once smartsheet is being used to collect numbers and the other... not working countifs smartsheet community https://community.smartsheet.com/discussion/103512/countifs-for-today-calculation Countifs for today calculation - Smartsheet Community Hi there! I'm trying to bring items from multiple sheets to populate a metric sheets. Basically, I would need a hand to bring the following data to count how... for today countifs calculation smartsheet community https://community.smartsheet.com/discussion/88918/countifs-with-criteria-on-2-different-ranges Countifs with criteria on 2 different ranges - Smartsheet Community hello, I have formulas in a metrics sheet looking at information in a second sheet. I want to count the number of items in the second sheet that meet both a... countifs criteria different ranges smartsheet https://community.smartsheet.com/discussion/139348/countifs-sumifs-with-multiple-criteria-which-reference-another-sheet Countifs/Sumifs with multiple criteria which reference another sheet - Smartsheet Community I'm trying to make a Metrics sheet to use on a dashboard. I would like to count all of the instances of each (text) heading which fall during this month, then... multiple criteria countifs sumifs https://community.smartsheet.com/discussion/comment/428373 COUNTIFS with multiple criteria - Smartsheet Community I am trying to count the number of projects with a due date in the past and a Status of In Progress, In Review, or On Hold. This is what I have, but it returns... multiple criteria countifs smartsheet community https://community.smartsheet.com/discussion/102834/countifs-cross-sheet-has-multi-select-drop-downs-and-multiple-criteria COUNTIFS, CROSS SHEET, HAS, MULTI-SELECT DROP DOWNS AND MULTIPLE CRITERIA - Smartsheet Community I feel like I've been going crazy. Trying to get a count of how many [Primary Column]45 appear when the other ranges have the listed criteria. All ranges are... https://community.smartsheet.com/discussion/83678/countifs-contains-problems COUNTIFS CONTAINS problems - Smartsheet Community Hello, I am trying to create a formula that will count the cells across spreadsheets using COUNTIFS and CONTAINS. My formula works, however I don't believe it... countifs contains problems smartsheet community https://community.fabric.microsoft.com/t5/Desktop/Countifs-to-filter-if-date-today/td-p/2115220 Solved: Countifs to filter if date = today() - Microsoft Fabric Community Oct 4, 2021 - Solved: Hi guys, Need your help with a newbie coming across from Excel. I need DAX to count if the entries were based on today. I've tried using microsoft fabric solved countifs filter date https://community.smartsheet.com/discussion/129260/countifs-formula-counting-macbook-pro-instances Countifs formula: Counting "MacBook Pro" Instances - Smartsheet Community Hi there, I need help with counting Asset Models by Keyword and by office location. Goal: I want to sum all Asset drop-down options that include the term... macbook pro countifs formula counting instances https://community.smartsheet.com/discussion/135681/countifs CountIFs - Smartsheet Community Creating a function to count certain states in one function listed below: =COUNTIFS([Travel State]:[Travel State], OR([Travel State]@cell = "CO", [Travel... countifs smartsheet community https://community.smartsheet.com/discussion/22941/countif-and-countifs-not-updating Countif and countifs not updating - Smartsheet Community I have created a smartsheet with a number of different formulas in to pull together monthly figures. I then use this information to populate charts in my... countif updating smartsheet community https://community.smartsheet.com/discussion/102677/countifs-using-multiselect-as-criterion COUNTIFS using MultiSelect as criterion - Smartsheet Community I have a sheet that is tracking all of the tasks users need to do in a year. They enter the recurrence of the task as Daily, Weekly, and Monthly. They also... countifs using multiselect criterion smartsheet https://community.smartsheet.com/discussion/98471/total-countifs-within-the-last-30-days-with-two-columns-of-data Total COUNTIFs within the last 30 days with two columns of data - Smartsheet Community Sort of new to this so having some issues. I'm trying to identify how many entries were made by employees within the last 30 days from a second data sheet. One... https://community.smartsheet.com/discussion/117812/unparseable-countifs-error-with-date Unparseable countifs error with date - Smartsheet Community =COUNTIFS([RACD]:[RACD]), DATE(24, 06, 30), [VPO/ED]:[VPO/ED], "Misterly" Trying to count number of accounts with an RACD Date of 06/30/24 assigned to VPO... with date countifs error smartsheet community https://techcommunity.microsoft.com/discussions/excelgeneral/wildcard-characters-not-working-in-countifs-function/4135730/replies/4135739 Wildcard characters not working in COUNTIFS function | Microsoft Community Hub Hi y'all,this was a real brain scratcher for me, I gave up and went to the internet looking for answers. Here's my situation:I have two columns. Column 1 has... not working microsoft community wildcard characters countifs https://community.smartsheet.com/discussion/82275/how-can-i-use-countifs-to-count-cells-with-a-date-and-cells-without-a-date-in-a-column How can I use COUNTIFS to count cells with a date and cells without a date in a column? -... How can I use COUNTIFS to count cells with a date and cells without a date in a column? https://community.smartsheet.com/discussion/76439/countifs-collect-index-match Countifs - Collect, Index, Match? - Smartsheet Community countifs collect index match smartsheet https://community.smartsheet.com/discussion/40946/countifs-to-include-cells-with-text COUNTIFS to include cells with text - Smartsheet Community I need to create a cross-sheet formula that counts the number of entries for a month and if there is text in another column. I've come up with the formula... with text countifs include cells smartsheet https://community.smartsheet.com/discussion/72938/countifs-formula-based-on-dates COUNTIFS Formula based on Dates - Smartsheet Community I'm trying to use the COUNTIFS Formula to count a range that has to be greater than 0 as well as within a certain month. I've gotten a formula to work but it... based on countifs formula dates smartsheet https://community.smartsheet.com/discussion/83096/using-find-with-countifs Using Find with COUNTIFS - Smartsheet Community I am trying to create a formula that references another sheet and counts how many times the name "James Comito" appears in column A and B if column C is marked... using find countifs smartsheet community https://community.smartsheet.com/discussion/87987/countifs-based-on-a-multi-select-column CountifS based on a multi select column - Smartsheet Community based on multi select countifs column smartsheet https://community.smartsheet.com/discussion/27546/countifs-on-multiple-columns-referencing-a-date-range COUNTIFS ON MULTIPLE COLUMNS REFERENCING A DATE RANGE - Smartsheet Community I am trying to summarise a Smartsheet that we log sales activities (F2F Calls and Phone Activity into). So I want to see how many Phone calls have been done in... multiple columns a date countifs referencing range https://community.smartsheet.com/discussion/123274/countifs-formula-with-date-ranges COUNTIFS FORMULA with DATE RANGES - Smartsheet Community I have a sheet with 2,000 events with lots of details, but I am trying to generate a quick report that shows events scheduled for every month. Table: Event... with date countifs formula ranges smartsheet https://community.smartsheet.com/discussion/63136/countifs-function-to-count-ratings-by-location-within-the-past-7-days Countifs function to count ratings by location within the past 7 days - Smartsheet Community I am trying to create a countifs function to count 5-star ratings by restaurant location published within the past 7 days. The published column contains dates....