So, I think I have really big LOGIC problem or may be there is some feature of appsheet that I miss out
I am working on a progress payment report app based on the inspections on construction sites.
I have a few calculations based on the other columns and calculations.
I don’t want to take much time of you, so I will try to explain without going deep just giving the formulas that I used.
In ny tables LOGEMENTS and P.P is predefined and user just enter FINIS column manually. So 1. and 2. formula returns the result instantly. But 3. formula dosen’t show up instantly because it sums up the P.PROGRESS column values if there are another matching values in APLICATION. But without saving and reopening the same form it doesn’t calculate A.PROGRESS
How can I “cache” P.PROGRESS column that will be sum, and return the result in instant?
1.FORMULA FOR PROGRESS COLUMN
[FINIS] / [LOGEMENTS] * LOOKUP([_THISROW.[PRODUCTION], "PRODUCTIONS","PRODUCTION", "P.P")
2.FORMULA FOR P.PROGRESS COLUMN
[PROGRESS] / LOOKUP ( [_THISROW].[PRODUCTION], "PRODUCTIONS", "PRODUCTION" , "P.P" )
3.FORMULA FOR A.PROGRESS COLUMN
3) SUM( SELECT(DATA[PROGRESS], [APLICATION]=_THISROW].[APLICATION] /LOOKUP([THISROW].[APLICATION], "APLICATIONS","APLICATION", "A.P") /COUNT( SELECT(PROJECTS[PROJECT], [PROJECT]=[_THISROW].[PROJECT]))