Help Needed.

edited 08/05/22 in Formulas and Functions

Why does this function not work ?

I'm trying to do a countif function that recongizes the status of an event but only looks at the events with valid due dates

=COUNTIFS(AND([Column4]@row = "In-progress", [Column6]@row = ISDATE(1)))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!