Hello There,
My concern is how to get the updated data and if no update gets the previews data.
sample data:
| Name | A | Date | B | Date |
| MC Sy | Collector | 08/25/2016 | Branch Name | 10/08/2019 |
| Abiah Teng | Cashier | 02/16/2017 | - | |
| Ashly Tan | Credit Asso. | 12/08/2017 | Credit Approver | 08/28/2019 |
I try this expression but the output its not working base on the output I need.
If(len(A)>,A,If(len(B)>,B))
The output should be that I need is like below:
| Name | B | Date |
| MC Sy | Branch Name | 10/08/2019 |
| Abiah Teng | Cashier | 02/16/2017 |
| Ashly Tan | Credit Approver | 08/28/2019 |
Is there any other way for this kind of concern?
Best Regards,
Bing
