Appsheet automatically adds ARRAYFORMULA to my excel sheets

[Reyad48]

Can anyone help me understand how to stop appsheet from adding arrayformula to the expressions in my excel sheet 

It adds them to all the cells with an excel expression in them, for example this is one expression

=MAX(IF(A2='Forecast Log'!A:A,'Forecast Log'!C:C))

after re-generating the schema, appsheet won't stop wrapping my expressions in arrayformula , and since it is not supported in excel the entire app falls apart giving the error NAME? in these cells 

Can anyone help 

[Tijesuni]

Here are a few workarounds to fix the issue:

1. Use a Named Range Instead of a Full Column Reference

• Instead of using a full-column reference ('Forecast Log'!A:A and 'Forecast Log'!C:C), define a named range in Excel and reference it in the formula.
• Example:
• Select the A and C columns in 'Forecast Log'.
• Name the range (e.g., ForecastA and ForecastC).

Update your formula:
=MAX(IF(A2=ForecastA,ForecastC))

•  

2. Store Formulas Outside of AppSheet-Tracked Columns

• Keep AppSheet from overriding your formulas by storing them in columns that AppSheet does not update.
• Use a separate column in your spreadsheet for calculations and only reference them in AppSheet.

3. Use Virtual Columns Instead of Sheet Formulas

• If the formula is needed only in the AppSheet app, try using an AppSheet virtual column instead.
• In AppSheet, go to Data → Columns, select your table, and add a virtual column with an equivalent expression.

4. Turn Off Automatic Schema Regeneration

• Every time you regenerate the schema, AppSheet tries to modify Excel formulas. To prevent this:
• Manually delete the ARRAYFORMULA every time after regenerating.
• Instead of automatic regeneration, update schema changes manually.

5. Manually Replace ARRAYFORMULA

• If you must regenerate the schema, go back and manually remove ARRAYFORMULA from each affected cell in Excel.

Let me know if you need help implementing any of these