=COUNTIF field has any value

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


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.  


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!