Sumif and ifs last week

04/08/21
Answered - Pending Review

Hi I'm having problem with my formula not giving me the total hours for the last week. Could someone please let me know if I'm doing something wrong. There should be hours calculated however, it is showing as 0


=SUMIF([Week]:[Week], WEEKNUMBER(TODAY() - 1), [Work Hours]:[Work Hours])

=SUMIFS([Work Hours]:[Work Hours], [Week]:[Week], WEEKNUMBER(TODAY() - 1), [Non Billable]:[Non Billable], 0)


Answers

  • Bassam.M KhalilBassam.M Khalil ✭✭✭✭✭
    edited 04/08/21

    Hi @kari1282

    Hope you are fine, please try the following formula:

    =SUMIFS([Work Hours]:[Work Hours], [Non Billable]:[Non Billable], 0, Week:Week, WEEKNUMBER(TODAY()) - 1)

    the following screenshot shows the result, you can test it in Published Sheet


    Best Regards

    Bassam.M Khalil


    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as the accepted answer. It will make it easier for other Smartsheet Community members to find this solution or help to answer their questions.

  • kari1282kari1282 ✭✭✭✭✭

    I copy the formula and I'm still getting 0

    =SUMIFS([Work Hours]:[Work Hours], [Non Billable]:[Non Billable], 0, Week:Week, WEEKNUMBER(TODAY()) - 1)



  • kari1282kari1282 ✭✭✭✭✭

    Thank you I figured out the propblem.

Sign In or Register to comment.