Count If Assigned to... and status not Complete (two columns criteria)


Hi All,

I have a column called 'Assigned To' - this contains smart sheet contacts from a drop-down. (can be multiple people) per task.

The second column is called 'Status' - It has a limited range of selections. Open, Complete etc (can only be one selection)

I am trying to create a formula that will solve this text description....

Count the total number of NOT "Complete" tasks for "Assigned Name", on the SAME action item row.

Any thoughts? I've reviewed the smart sheet sample formulas but cant seem to combine them to get what i need.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!