I’m developing a delivery application that our deliveryman updates the status when he finishes a delivery, or when it is cancelled. In addition, we have the status “Postponed to tomorrow” which, for now, needs to be manually selected. I want the status in my app and in my googlesheet to update to “Postponed to tomorrow” automatically when the “Delivered date” column is greater than TODAY(). How can I do this?
I don’t know if it’s relevant to the situation, but my Data Table has a security filter to show only “TODAY()” data.