Hi there! I am trying to insert a formula that reads two columns from another sheet. I want to count the cells if one column equals the Primary column name in my new sheet and the other does NOT equal the status "Scheduling Complete". I can't figure it out! Below is what I currently have and have tried dozens of versions... Tried with/without AND also....

Thanks for your help!

=COUNTIFS({Interview Request Form - MASTER Coordinator}, [Primary Column]@row, AND([{Interview Request Form - MASTER Status}, <>"Scheduling Complete"]))

=COUNTIFS({Interview Request Form - MASTER Coordinator}, [Primary Column]@row, [{Interview Request Form - MASTER Status}, <>"Scheduling Complete"])


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!