automatically update status when expired on appsheet

[nhatphan]

Hello everyone.

For example, I have 3 columns of data on the appsheet as follows.

To,From, Status. 

now i want when from is equal to today the status on will change to off.

illustration below if today is equal to : 11/28/2022, then the shared state switches to off.

Thanks and Have a nice day.

[Steve]

Use virtual columns - AppSheet Help