Hi,
We use Spill Formula, but it doesn’t recover after RefreshDynamicArrayFormulas and CalculateFormula
We have two sheets:
Sheet3 → Contains table Table1 it contains the data
Sheet4 → User function =@MY_FUNC(1) whic…...Sheet4 → Spill formula using =FILTER(…) based on Table1 and cell...=IF(C2=“All”,FILTER(Table1,Table1[Column6]=“empty”,“1”),FILTER(Table1...