COUNTIF with a certain word in a week

NickJonesLG ✭✭✭
edited 02/15/24 in Formulas and Functions

Hi All,

A client wants to be able to see how many calls were logged in thier current working week . However the working week begins on a Friday 00:00am and ends Thursday 11:59pm.

I'm after a formula to count all entries with the word "Aberdeen" in the Column called "Club" in the mentioned working week . This counter would then be reset when the new working week begins

I have the Count formula : =COUNTIFS(Club:Club, CONTAINS("Aberdeen", @cell))

I just need to include the Working Week range to the formaula .



  • NickJonesLG
    NickJonesLG ✭✭✭

    So need to add something to this formula : =COUNTIFS(Club:Club, CONTAINS("Aberdeen", @cell))

    which only searches for any "Aberdeen"s that were this working working week and then resets when the new working week begins ( Friday 00:00am )

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!