-
Can I use a COUNTIFS formula based on the date a cell was populated?
Can I use a COUNTIFS formula based on the date I added a value to a cell? The information within the cell will not be a date. I have a Smartsheet with a list of project ideas. Once it's added to our project management tool, it gets a number (ex: 123456). I have a column for "Project Number". I would like to add a line to…
-
Counting single values with multiple criteria
I need a little help with a formula in Smartsheet, I am trying to count the number of employees who are over utilised (> 105) but some employees have multiple entries (same utilisation, so only need 1 entry in the count). Answer below should be 3
-
Countif Child rows with specific condition.
Hi All, Need help on the formula am using in sheet summary. Am trying to count child rows that has specific colour. Getting error #UNPARSEABLE on below formula. =COUNTIF(CHILDREN([Schedule Health]:[Schedule Health], "Red")) Appreciate the help!
-
COUNTIF is a reference to another sheet or is a link
I need help to count if a cell contains any link or any reference to another smartsheet. Not a specific file, but any file. Thanks!
-
How to cound items in a RAID log using the Health Color
Hello - I would like to reoprt the # of green, vs. yellow vs. red items in my RAID log and use that # in a chart on dashboard. I use a lot of countifs but I am not sure how to countif the health column. It shows a green dot so I want to count that as one green. Thanks for any help you can give. Best Regards, Christine
-
Help with reporting between 2 dates
Hi, I am having issues with working out how to get a total count on dates 1st to count how many of those tasks were updated under 7 days. =COUNTIFS({person1}, [Person1]@row, {Date updated}, <=TODAY(7)) 2nd to count how many where done between 7 days and under 14 day =COUNTIFS({Person1}, [Person1]@row, {Date updated},…
-
How to count values if either of two conditions are true
I have two sheets: Sheet A and Sheet B I would like to count the number of cells in Sheet A, Column A and Sheet B, Column B that have the value "Liver". Both sheets are stored under the same folder.
-
Sheet Reference Formula for Last Week?
I have a source sheet set up that has three columns: State, Delivery Date and =WEEKNUMBER from the Delivery Date formula. I have a metric sheet set up where I want to use a =COUNTIF formula to calculate rows from the source sheet with deliveries by state, and I want it to count by delivery date from the previous week (not…
-
CONTAINS to count cells with specific string of numbers
Is there a way to use COUNTIFS and CONTAINS to count cells that include a specific string of numbers as well as cells that include that string plus something else? In the example below, I'm trying to count the number of students who are taking the course with the Code "20659," which should include those taking only that…
-
Countifs where sheet range is formula returning a number and criterion is sheet summary dynamic drop
I have a column called '"Wave" which shows a number 1-10. The value is returned on some rows from a =PARENT formula and on some rows it's hardcoded. (I understand it should be either formula or hardcoded but go with me here...) I have a sheet summary which works perfectly well when the 'Wave' column in my sheet is…