Forum Discussion

EZimmet's avatar
EZimmet
Icon for Resolver I rankResolver I
4 years ago
Solved

Nested If

Trying to do a nested if have issue if someone can please assist - TY    Any of conditions to the left need to populate a 3rd column tagged to be reviewed                   = Ta...
Help Requested
Nested IF
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    The syntax is a bit off. Try adjusting it like this:

    if List.Contains({"Disposed", "Inventory", "Missing", "Return to Client"}, [DeviceStatus]) and [DisplayLabel] = "Live"
then "Review Live"
else if List.Contains({"Active", "Inventory", "No Power"}, [DeviceStatus]) and [DisplayLabel] = "Disposed Devices"
then "Review Disposed"
else if [DeviceStatus] = "Disposed" and [DisplayLabel] = "Old Devices"
then "Review Old"
else null
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

The syntax is a bit off. Try adjusting it like this:

if List.Contains({"Disposed", "Inventory", "Missing", "Return to Client"}, [DeviceStatus]) and [DisplayLabel] = "Live"
then "Review Live"
else if List.Contains({"Active", "Inventory", "No Power"}, [DeviceStatus]) and [DisplayLabel] = "Disposed Devices"
then "Review Disposed"
else if [DeviceStatus] = "Disposed" and [DisplayLabel] = "Old Devices"
then "Review Old"
else null
EZimmet's avatar
EZimmet
Icon for Resolver I rankResolver I
4 years ago

Thank you Sir 

This worked all i needed to do is add last   )