Countif and an And!

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!