-
Use of COUNTIF and CONTAINS to search 2 columns for a specific condition
Hello all!!!; I am trying to search in rows across 2 columns for a specific condition that I want to count the total number of. These columns are in the same sheet (See attached). My formula that returns "UNPARSEBLE" is: =COUNTIF([AssignedText]:[AssignedText], CONTAINS("First.Last1", @cell, [NeedsText]:[NeedsText],…
-
Cell Link/Reference - COUNT Question
Good Afternoon all, hoping for some assistance with this formula I am putting together. For my Number of Dealers Column on Sheet 1, I am trying to get a formula to count the number of Dealer ID's that fall under a certain Market. For Sheet 1 the formula will be looking up cells from Sheet 2. The formula needs to match the…
-
COUNTIFS for prior period
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')@Row, but none that appear to be scalable. I don't want to have to recreate any summary fields (with formulas)/reports/dash…
-
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},…
