Auto update App Formula Field

[zenone]

Hello, I'm trying to have AppSheet auto update a form field when the data changes in my google sheets i.e. when the referenced cell "Speaker" name changes in google sheets I would like to show the new name in the "Speaker" field in AppSheet.

Currently when the "Speaker" name changes in google sheets, it won't update the field even when I resync. It seems after a few minutes it will eventually update and change to the new name, but I would like it to update the name as soon as the google sheet is updated.

Google sheets data example: 

When Column I changes I would like to update the new "Speaker" name in the form field in AppSheet.  Any suggestions?