Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

If Help

Hello, I am having isues with creating a new column using mutiple columns with an IF statement. I am looking to do something like this If timeissue = good and week = 1 then sum actual hours, ...

Need Help

Anonymous
6 years ago
Anonymous

Result =
SWITCH (
    [Time Issue],
    "Good", SWITCH (
        Sheet1[Week],
        1, FORMAT (
            CALCULATE ( SUM ( Sheet1[Acutaul Hour] ), FILTER ( Sheet1, Sheet1[Week] = 1 ) ),
            BLANK ()
        )
    ),
    "Missing Timesheet", "Missing Timesheet"
)

Paul

Anonymous

Not applicable

6 years ago

Hi, Anonymous

Hope this is what you are looking for:

Result =
SWITCH (
    [Time Issue],
    "Good", SWITCH ( Sheet1[Week], 1, FORMAT ( SUM ( Sheet1[Actual Hours] ), BLANK () ) ),
    "Missing Timesheet", "Missing Timesheet"
)

The result should be similar to my sample table:

Best,

Paul

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.