Forum Discussion
EZimmet
Resolver I
Resolver INested 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...
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
Super User
Super UserThe 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
EZimmetThank you Sir
This worked all i needed to do is add last )