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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!