App sheet display error value

I have link my google spreadsheet to my app sheet.

In my spreadsheet, got column with formula that it will have value once equal to certain value in other sheet. 

However I cannot display the value in app sheet and it generate error #VALUE.

Can anyone help me on this problem. Thanks

0 1 48
1 REPLY 1

Please post some screenshots

Top Labels in this Space