=COUNTIF field has any value

Kyler Keel
edited 12/09/19 in Formulas and Functions

Hello, 

My current incorrect statement is as follows: 

=COUNTIF(Plant:Plant, "DC", [Assigned To]:[Assigned To], NOT(ISBLANK([Assigned To]:[Assigned To])))

I am attempting to count the number of fields with any value in the "Assigned To" column with the plant column being "DC". 

I have made numerous failed attempts to find help with this by reading current info.

Any help would be greatly appreciated.  

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!