Formula to change status based on sheet value
I'm trying to change a status (from a dropdown box in sheet summary, based on a date field. When a check box checked the status would change.
Sheet Summary Field is "Construction Status", drop down list is:
- Not Started
- Permitting In Progress
- Permitted Inventory
- Slab Starts In Progress
- Slab Starts Inventory
- Vertical Construction
- Completed Inventory
Each of these would be changed based on when a particular "Task" is completed.
Sheet Summary field would default to "Not Started"
Sheet Summary Status would change to "Permitting in Progress" when task "Permit Prep (Docs to Runner)" is "Started" (checkbox field).
Sheet Summary Status would change to "Permitted Inventory" when task "Receive Permit" is "Done" (Checkbox field) is checked.
So on and so on...... through the rest of the list in the construction status dropdown options.
If someone can help get this started, I can probably finish it out. Any help would be appreciated.