Forum Discussion
Solved
Switch
Hi good day can anyone help me on my new column base from my table below, basically if the comments is Cancelled and Tobe- Cancelled the actual colunm should reflect Non-Workable. OUTPUT ...
- Actual = SWITCH(Test[Comment], "Cancelled", "Non-Workable", "Tobe-Cancelled", "Non-Workable", Test[Status])
Just add [Status] like this
Actual = SWITCH( TRUE(), [Comments] = "Cancelled" || [Comments] = "Tobe- Cancelled" , "Non-Workable", [Status] )regards
Phil
Just add [Status] like this
Actual =
SWITCH(
TRUE(),
[Comments] = "Cancelled" || [Comments] = "Tobe- Cancelled" , "Non-Workable",
[Status]
)
regards
Phil