Forum Discussion
Solved
Add Custom Column and check for value against entire column
Hi, (apologies, its difficult to title this question...) I have two columns: A B Cust1 NormalOrder Cust2 NormalOrder Cust1 NormalOrder Cust2 SpecialOrder...
Try this as calculated column
Column = if( CONTAINS(Filter(Table1,[A]=earlier([A])),[B],"SpecialOrder"),"Special","Normal")
Zubair_Muhammad
Community Champion
Community Champion
Try this as calculated column
Column = if( CONTAINS(Filter(Table1,[A]=earlier([A])),[B],"SpecialOrder"),"Special","Normal")