Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
formula help
I am attempting to get a formula to count a range if the column next to it has the correct category. for example
DF 1.1
DV 2.1
DF 3.3
DF 1.2
DV 2.1
I want to count how many numbers lay between 1 and 2 in the category DF, and am struggling to get the program to do this. Any help would be appreciated.
Comments

Hey Luke,
Have you tried the CountIF function? I know I use the formula below to count how many projects are in "Red"
=COUNTIF(Status3:Status90, "Red")

I am sorry I don't really understand what you are trying to count, or I would come up with a formula to help. But my example should be a good template for you.

That would work if there wasn't a range. Using a range throws logic into it that I haven't been able to get the countif function to accept so far. Thanks though

See if this works... replace primary column with your column name. (Remove brackets [ ] if there are no spaces in the column name]
=COUNTIF([Primary Column]:[Primary Column], OR(LEFT(@cell, 4) = "DF 1", LEFT(@cell, 4) = "DF 2"))
https://help.smartsheet.com/articles/2476491/createefficientformulaswithatcell
https://help.smartsheet.com/articles/775363usingformulas#left

Thanks. I always seem to have problems with the countif function. I appreciate the help!

You are welcome. Formulas are tricky, but over time they will grow on you. The nuances of Smartsheet will do the same.