How to create IF Formula between 2 table

AppSheet AppSheet Q&A
1

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

2

Can you give more information, such as the snapshot of both tables, what it the relation between the two tables, and where do you want to put this formula?

2 Likes