Forum Discussion

Arkan_Hazm_'s avatar
Arkan_Hazm_
Frequent Visitor
3 years ago
Solved

Help with Complex calculated column

Hello all,
Please advise if you can help me.
I need the last colomn

EX:

LineSequenceStatusdateIs Order Has Pending
255461Order16/06/2021It has Pending
255462Pending16/06/2021 
255463Approved16/06/2021 
255464Invoiced16/06/2021 
255465Shipped16/06/2021 
255466Delivered16/06/2021 
255467Order13/07/2021Not Pending
255468Approved13/07/2021 
255469Invoiced13/07/2021 
2554610Shipped19/07/2021 
2554611Order19/07/2021Not Pending
2554612Invoiced19/07/2021 
2554613Shipped19/07/2021