Countif
Discussion List
- Hi, I am looking to build a dashboard that displays prior month/quarter/year data. I have found ways to do this from a rolling perspective (Year (Today())-1) or specifying a year, such as (Year='2023'…
- 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 tim…
- 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 p…
- 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…
- 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]:[Sc…
- 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!
- 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 colum…
- 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)…
- 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.
- 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 calcula…