Data not updated in googlesheet, while app formula expression results are ok

[RavindraMurthy]

Namaste, I created app formula to populate Status column in my Task management app, based on plan, start , end and completion date status column expected to populate with Planned, Scheduled and Completed. with the app formula expression when tested in Table Data - AppSheet I am able to see Planned , Scheduled and completed as expected in Expression result, however in googlesheet Status column is not populated, with the help of Chatgpt I tried to debug, but could not succeed, please suggest how to resolve this problem

Ravindra Murthy

[AleksiAlkio · Accepted solution]

Have you opened one record on a form view and saved it?

[AleksiAlkio · Accepted solution]

Have you opened one record on a form view and saved it?

[RavindraMurthy]

Yes, thanks for the solution. For new forms saved it worked, however for existing data I had to edit some fields and re save to get the result. It is done.

[AleksiAlkio · Accepted solution]

Or.. you could show the same action and trigger the Bot with it.