Additional Code to be added

mike.thorpe17421 ✭✭✭✭✭
edited 06/21/22 in Formulas and Functions

I have created the following formula to count the number of cells for 2 specific requirements

=COUNTIFS({Reference Sheet 1}, Country@row, {Reference Sheet 1}, Name of topic)

This gives me what I want but I now need to add new criteria that looks at another column which is a date and I only want to count where a date exists and secondly at another column that contains either the words "To be launched" or "No launch planned" or "On Hold"

Any help much appreciated

Many thanks



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!