-
How to do Countifs when drop down allows multiple select
Hello, I am trying to set up a formula that would count a contract number that is in a cell that allows multiple drop downs. I have looked up "Has" and "Contains" and I am pretty sure I am just following the formula wrong? Can anyone help?
-
How to show a blank instead of 0 using countsif?
I've tried a couple different formulas and can't get it to work, probably something small I am missing. Can anyone help? =IF({MY25 CTM Detail Report Range 1} = 0, " ", COUNTIFS ({MY25 CTM Detail Report Range 1}, "(7)Other Matter Requiring Plan Review"))
-
Project Status Formula Help
I have a formula I need help with for the top level of my project checklist hierarchy. Overall Project Status - this is looking only at the highest level rows which are indicated by the helper column Hierarchy=0. The objective of the formula is as follows: If the Project Override field (in the Sheet Summary) is filled out…
-
Project Status Formula Help
I have a formula I need help with for the top level of my project checklist hierarchy. Overall Project Status - this is looking only at the highest level rows which are indicated by the helper column Hierarchy=0. The objective of the formula is as follows: If the Project Override field (in the Sheet Summary) is filled out…
-
Help with a COUNTIFS Formula that contains OR and Divide to calculate a %
Hey Guys I wonder could i pick your brains to iron out the kinks in my formula I would like to calculate a % based upon the following references Sheet Reference {EPIC} Value "GBT-xxxx" Sheet reference {JIRA STATUS} Value "Pass" or "Fail/Issue" or "Gap" or "Pass - Now Fail" or "N/A (Not Applicable)" Divided by 234 which is…
-
Multi-Line Chart from Imported Excel Data based on Counts Per Date
Hello! Got a problem that's confusing me because I'm used to Excel and can't find a way to do this on SmartSheets. Context: I have a CSV that I export from a database that contains info about design issues such as ID #, Status, Create on Date, Updated on Date. I'm using Smartsheets as a project management tool and I'm…
-
Challenges with combining SUMIFS and COUNTIFS
I am using the Sheet Summary to input formulas helping me to track the COUNT of installs that took place in a given month/year. But now I want to SUM how many assets were installed at that location using the same date criteria. My formulas below are allowing me to COUNT how many rows (AKA customer locations) fit my…
-
Count Multiple Values in the Same Column
I'm trying to write a Sheet Summary formula that will tell me how many times multiple criteria appears in one column based on the conditions of another column. I'm struggling with the OR function, and all my COUNTIFS formulas result in 0. I'm using a simple table to help me learn how to write Sheet Summary formulas, but my…
-
CountIF formula between two sheets
Hello, Can someone please point out what's wrong in this formula: =(COUNTIFS({Applied Grants}, "Applied", {submission date}), AND(@cell >= DATE (2025, 1, 1), @cell <= DATE(2025, 12, 31)) I would like to count the total number of grants with the status "Applied" between the Submission date of Jan 1 - Dec 31 2025. Please…
-
Duplicate Checkbox Column
I've been perusing the forums for how to have a checkbox column check a duplicate of a row and I can't get any of them to work the way I want them to. Criteria for checkbox being checked: Row ID shows up more than once AND Created column is not the most recent Once I get this figured out, I will have an automation where…
