I have 2 table
- pcr table
- lpj table
i want to create formula on pcr table in column status_pcr, with lpj table in column status_lpj as reference, i use IF formula in column status_pcr = IF((lpj,[status_lpj])=“Open”,“Open”,“Closed”), but the formula doesn’t work.
How to create right formula between table?
Need your help