How do I create a formula to activate a flag if a column has not been changed?
I want to be able to send an automatic update request when people fail to add updates to a text column (Called Updates). Currently, this doesn't seem possible. But I thought of a workaround that may work if someone could point me in the direction of writing a formula. I thought of having a flag column that will go up if someone in a contact list column does not change a particular column in the last 10 days. And then send an automatic update request to go out whenever that flag is up. Any ideas of how I would write this formula for the flag column?
Help Article Resources
Check out the Formula Handbook template!