How to count all entries for each day for this week

Options

I am trying to find a logical function for count rows that were added on sunday, monday...friday

on this week only(and refresh it to the next one).


can you please help me?

thank you!

Answers

  • davital
    davital ✭✭
    Options

    the function I typed:

    =COUNTIFS({Gym Check-In per Day}, {Gym Check-In per Day} = 1, {Gym Check-In per Date}, WEEKNUMBER({Gym Check-In per Date}) = WEEKNUMBER(TODAY()))

    I want to count all the entries that were on sunday and in this week(in addition want to refresh the week after it will end)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!