Display value from Column

[Anonymous]

I am trying to figure out the best solution to display the value from Order No. If no value in Order No exists, then I would like to display PO No. If there is no value in either, display "Unprocessed". The goal for this is to display an Order No/PO No/ Unprocessed for each item number based off the demand date and the Par location ID it was ordered from. Let me know if additional info is required. Thanks

[Greg_Deckler · Accepted solution]

So, a column form of this would be:

Column = 
SWITCH(TRUE()
  ISBLANK([Order No]) && ISBLANK([PO No]),"Unprocessed",
  ISBLANK([Order No[), [Po No],
  [Order No]
)

[Anonymous]

Greg,

This worked great. Thanks

Also just if anyone else uses this solution, don't forget the comma after SWITCH(TRUE( )

Column = 
SWITCH(TRUE(),
  ISBLANK([Order No]) && ISBLANK([PO No]),"Unprocessed",
  ISBLANK([Order No[), [Po No],
  [Order No]
)

[Greg_Deckler]

Ack! My bad, syntax error! Glad it worked though!!