Issue with auto compute function

[TKSriwat]

Hi everyone, I have an issue regarding auto computation of the formula as below;

FORMULAR:

IF(ISNUMBER(RC[-1]),RANK(RC[-1],C[-1]:C[-1])+COUNTIF(R2C17:RC[-1],RC[-1])-1,""

Expectation in Google Sheet:

IF(ISNUMBER(Q22),RANK(Q22,Q:Q)+COUNTIF($Q$2:Q22,Q22)-1,"" )

Actual Output:

IF(ISNUMBER(Q22),RANK(Q22,C[-1]:C[-1])+COUNTIF($Q$2:Q22,Q22)-1,"" )

I have done the same formula with other spreadsheets and it's all worked. However, there is one spreadsheet that couldn't be auto-computed like the other. Could you guys please give me any solution for this issue?

Thank you in advance.

[Marc_Dillon]

I'd advise that you either translate your formula into an Appsheet App Formula instead of using Spreadsheet Formula, or that you use a single ARRAYFORMULA in the header of your sheet and not allow Appsheet to even know about it.