Issue with Auto-Complete Functionality Not Reflecting Changes in App

[Trestantin]

Hello everyone,

I'm facing an issue with the auto-complete feature. Even though I'm using the condition correctly, it doesn't reflect the change in the app. Essentially, what I'm trying to achieve is this: if the 'category' field contains the word "administrated", then the value in the [me] field should be multiplied by 100. If it's any other category, the value should remain unchanged.

Interestingly, during testing, the expression results are displayed correctly. Any insights or suggestions would be greatly appreciated.

Thank you!

[Marc_Dillon · Accepted solution]

Appsheet doesn't do iterative calculations. You'd need an additional column beside [me] to hold this formula.

[Trestantin]

Thank you for reply! I set condition in spreadsheet in a new column and everything works fine.