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 tablesLOGEMENTSandP.Pis predefined and user just enterFINIScolumn manually. So 1. and 2. formula returns the result instantly. But 3. formula dosen’t show up instantly because it sums up theP.PROGRESScolumn values if there are another matching values inAPLICATION. But without saving and reopening the same form it doesn’t calculateA.PROGRESS

How can I “cache”P.PROGRESScolumn 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]))
```