I have created an app that I would like to have the Status of the project change based on when a date is filled out. I have 4 dates. 1. Date Received 2. Approval Date 3. Date Sent to Finance 4. Date Item Received
When the user placed a date in the date received i want it to change status to OPEN
but when a date is placed into the approval date I want the status to change to “Project Approved” I figured out how to make it set to open but I can not figure out how to get it to change beyond that.