Formula for writing review status updates
OK, so this seems like it's going to be a long shot... hopefully do-able though!
I currently have 4 Sheets as follows:
- Safety Report - this is where employees submit a form containing information about a hazard, near miss or incident.
- Safety Review - this sheet is where the safety manager starts their initial review of the hazard/near miss/incident
- Safety Investigation - this is where the safety manager adds information about their investigation
- Safety Assurance - where the safety manager tracks the assurance activities and effectiveness of corrective actions, and then a checkbox for when the safety assurance is complete and the investigation closed
In sheet 2 I have a review status column, where the safety manager updates the status according to what phase they are working on WRT that safety report. The safety managers have identified that they don't want to have to keep going back to sheet 2 to update this status. So, I have added a checkbox column in sheet 2, 3 and 4, where they check the box when they move on to that phase. From that checkbox I want to write a formula that changes the status in the Review Status column.
The of the different status are:
- Initial Safety Review
- Corrective Action Implementation
- Assurance Review
- Approval Request
So, I see the formula saying something like
=IF(Sheet 2 Safety Review is Checked / Yes, then 'Sheet 2 Review Status is "Initial Safety Review"), IF(Sheet 3 Safety Investigation is Checked / Yes, then 'Sheet 2 Review Status is "Investigation"), IF(Sheet 3 Corrective Actions Identified is Checked / Yes, then Sheet 2 Review Status is "Corrective Action Implementation"), IF(Sheet 4 Assurance Review is Checked / yes, then Sheet 2 Review Status is "Assurance Review"), IF(Sheet 4 Approval Request is Checked / Yes, then Sheet 2 Review Status is "Approval Request"), IF(Sheet 4 Closed is Checked / Yes, then Sheet 2 Review Status is "Closed")
Sheet 2 Checkbox for the Safety Review
Sheet 2 Review Status that I'd like to be automatically updated according to when checkboxes are updated
Help Article Resources
Check out the Formula Handbook template!