Formula checkbox needs to uncheck when conditions change
I have a formula checkbox that says
If(([Related Department or Group] = 13) and Contains(ToText([Tools]), "MVR") true,false)
This works fine until [Tools] changes from "MVR" to ""
What happens is, an anonymous user submits a request. They are in [Related Department or Group] 13, They select "MVR" and "Service Metrics" in [Tools]. They save the request. My formula checkbox checks because "MVR" was selected. That is correct.
The Admin gets the request and decides the users does not need "MVR" so they remove it. But my formula checkbox does not uncheck. I need it to uncheck. How do I fix this?
If(([Related Department or Group] = 13) and Contains(ToText([Tools]), "MVR") true,false)
This works fine until [Tools] changes from "MVR" to ""
What happens is, an anonymous user submits a request. They are in [Related Department or Group] 13, They select "MVR" and "Service Metrics" in [Tools]. They save the request. My formula checkbox checks because "MVR" was selected. That is correct.
The Admin gets the request and decides the users does not need "MVR" so they remove it. But my formula checkbox does not uncheck. I need it to uncheck. How do I fix this?
