count if to determine the duration in a week

This discussion was created from comments split from: COUNTIFS between dates & criteria..


  • Hi, I am trying to use count if to determine the duration in a week:

    • The duration is between 03/04/2023 to 07/04/2023
    • the "assigned to is = to team (in my new sheet)

    Assigned to is column 3

    duration is column 4

    start date is column 5

    end date is column 6

    I want to do it in this table:

    • So the week column will be the count of the previous thing. Need to match the name according to the assigned to in sheet 1 and the team in sheet 2 and then in sheet 2, count the duration that sheet 1 have between 03/04/2023 to 07/04/2023 but match the previous condition.

  • Genevieve P.
    Genevieve P. Employee Admin

    Hey @Dianak123

    My apologies, I'm struggling to understand exactly what it is you're looking to do.

    Is there any way you could provide full screen captures of both sheets (either blocking out sensitive data or using "example" sheets that have test data in them)? It would also be helpful to see some typed out examples of what you want the formula to do.

    E.g. are you wanting a COUNT of the number of working days, or a COUNT of the number of rows in the previous sheet that meet your criteria? Or are you looking to return a Date if the Name matches?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!