Hi Steve, I solved the issue, thanks btw.
But today I am having another issue.
In one form, I have two entries which need to create dropdown list and those two entries are going to refer same data sheet and and same particular row I used Valid If to make them refer that particular row.
However, only the first entry is able capture the date from the data sheet the second entry is not.
As you can see from the Images I uploaded.
The the Appsheet inferface, “Part of Rejection 1” and Part of Rejection 02" are suppose to have same interface same dropdown list content due I set same formula on Valid If, but somehow is not.
Perhaps I misunderstanding on Valid If behavior.
Kindly help on that.
Appsheet InterfaceAppsheet Part of Rejection 1 & 02 Valid If Formula