Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Display value from Column

  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 "U...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    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]
)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    Greg_Deckler
    Community Champion
    7 years ago

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