Panoply's ingestion process ignores formulas from a Google Sheets data source. It ingests only the results or the value of the cells and not the actual formula.
In the screenshot example above, the value for cell C3 is
800 and not
A3+B3 (the underlying formula of cell C3).
Similar to the way it works in Google Sheets, whenever the value of cells A3 or B3 changes, the value of cell C3 also updates. Then, when you pull in or collect the changed data from your Google Sheets data source, the relevant values in the Panoply table will change as well.