Formula counts only if yesterday was a weekday


Hello. I have a formula that counts how many calls an agent took the day before, but I need it not to count Saturdays or Sundays as the day before. Can someone please help me? Here is the formula I have so far.

=COUNTIFS([Agent (Username)]:[Agent (Username)], "Alexis Braxton (ag05ZjnuQISJOOsB63_XyffA)", Period:Period, TODAY(-1), Media:Media, <>"Chat")

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!