AppSheet allows for creating data-driven apps and is not suited for real-time purposes; you'd better think of having some backend that would read your data and update your app's database accordingly through API. However, users will not see the updated status until there's a new sync.
The best you can achieve is to implement this monitoring in a virtual column which would also recalculate only upon a new sync.
LinkedIn
Twitter
