Formula to count the how many times "Monday" is listed

This is for a ticketing system. I want to count the number of requests that come in on each day of the week. I am looking for a rolling YTD number.


I have a metrics sheet that pulls the data from a closed tickets sheet.


This is the formula I tried using:

=COUNTIFS({Resolved Date Range}, CONTAINS("Monday", @cell))


Any help would be appreciated.




Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!