In my google sheet, I created a formula to calculate how many calls our sales team has to do based on their target, it calculates that from another sheet.
=MAX(0,(H2-(COUNTIFS('Call History'!E:E,A2,'Call History'!B:B,G2,ARRAYFORMULA(MONTH('Call History'!H:H)),MONTH(TODAY())))))
It is picked up by Appsheet and translated to the following formula under Auto Compute – Spreadsheet formula
=ArrayFormula(MAX(0,(RC[-3]-(COUNTIFS('Call History'!C[-6]:C[-6],RC[-10],'Call History'!C[-9]:C[-9],RC[-4],MONTH('Call History'!C[-3]:C[-3]),MONTH(TODAY()))))))
the problem is when a new record is created the Spreadsheet formula is not applied and the cell is empty! any ideas on how to fix this?