-
Trigger automation based on a count or multiples of a count
Hello. Im testing out triggering an automation based on a countif, but I cant figure out the logic to apply the automation as the countif increases. For instance. I want the automation to run each time we get 5 submittals via a form for the same category. Right now I'm using a metric sheet and a countif with a mod…
-
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…