Forum Discussion
Solved
Multiple IF, AND statements in one column
Hey all, I have had incredible success finding solutions in this forum that I thought I would try my luck again! I am hoping to create a single column that tells me if an SLA missed or met base...
You can pretty much take your statement and convert it straight into a SWITCH
New Column = SWITCH( TRUE(), ISBLANK([SLA]),BLANK(), [SLA] = "60 Mins" && [Age_Hours] <=1,"SLA Met", [SLA] = "12 Hours" && [Age_Hours] <=12,"SLA Met", [SLA] = "24Hours" && [Age_Hours] <=24,"SLA Met", [SLA] = "3 Business Day" && [Bus Hours Open] <=27,"SLA Met", [SLA] = "4 Business Day" && [Bus Hours Open] <=36"SLA Met", [SLA] = "5 Business Day" && [Bus Hours Open] <=45"SLA Met", [SLA] = "10 Business Days" && [Bus Hours Open] <=90,"SLA Met", [SLA] = "Action Date" && [Action Date Resolution] = "Y","SLA Met", "SLA Fail")
You can pretty much take your statement and convert it straight into a SWITCH
New Column = SWITCH( TRUE(),
ISBLANK([SLA]),BLANK(),
[SLA] = "60 Mins" && [Age_Hours] <=1,"SLA Met",
[SLA] = "12 Hours" && [Age_Hours] <=12,"SLA Met",
[SLA] = "24Hours" && [Age_Hours] <=24,"SLA Met",
[SLA] = "3 Business Day" && [Bus Hours Open] <=27,"SLA Met",
[SLA] = "4 Business Day" && [Bus Hours Open] <=36"SLA Met",
[SLA] = "5 Business Day" && [Bus Hours Open] <=45"SLA Met",
[SLA] = "10 Business Days" && [Bus Hours Open] <=90,"SLA Met",
[SLA] = "Action Date" && [Action Date Resolution] = "Y","SLA Met",
"SLA Fail")
Thank you, this is perfect 😁
