Hi all, this is my first post here. I have been trying out Appsheet with a few nested Excel tables with references, take data entries and app formulas to calculate the data collected.
The Appsheet formula will take data from the ‘inner-most’ table and calculate backward to the table with the highest hierarchy.
My experience is that for the data to propagate backward, each of the related table needs to be manually save else the App formula will not calculate. This will be an ‘operation’ issue if the user has to go through such steps. Am I doing something wrong? Will having the formula in the Excel spreadsheet helps instead of using Appsheet formula? Thanks in advance.