Formula Values Are Not Syncing On My Google Sheet Database

Please help me find the solution to this Appsheet formula problem I am facing.

For Context

I am creating an inventory management application and for the product overview table, I want the available quantity of the product to be calculated from the value of other tables in google sheet.

The Problem

When I test my formulas, they work perfectly on the expression assistant on AppSheet as seen below.

However, the calculated information is not showing on my google sheet database or on the Appsheet table “Data Display” is not showing in my Application

Google sheet database

1 Like