Countif and an And!


Hi, got this far....

=COUNTIF(AND(Actionee:Actionee, "Jess Smith"), [Target date for updates]:[Target date for updates], <=TODAY())

Think I either have brackets or commas wrong! in essence count records where Actionee is Jess Smith and Target for updates column has date less than today.

Thanks in advance, Paul

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!