Forum Discussion

electrobrit's avatar
electrobrit
Icon for Post Patron rankPost Patron
3 years ago
Solved

conditional statement by name for weekly totals

I am trying to get total available hours by week which is usually 40 but one person works 20. In trying to get this in the table by person by week Is there a conditional statement I can use? if na...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi electrobrit ,

    Try

        Working Hours = 

    SWITCH(
        TRUE(),
        SELECTEDVALUE(Sheet1[Name]) = "John",20,40)


    BR

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi electrobrit ,

Try

    Working Hours = 

    SWITCH(
        TRUE(),
        SELECTEDVALUE(Sheet1[Name]) = "John",20,40)


BR