Autofill cell with a value based on another cell's value while still allowed to select from dropdown
I have a Sheet with 3 columns that have a restricted dropdown list: 'Not Started' 'In Progress' 'Rework' and 'Complete'.
Column 4 has a restricted dropdown list: 'Submitted' 'Resubmitted' and 'Rework'
A 5th column has a restricted dropdown list: 'Approved' 'Pending' and 'Revise & Resubmit'.
I want the first 4 columns mentioned to be allowed to select from their dropdown list, but if 'Revise & Resubmit' is selected in column 5, column 4 automatically changes to 'Rework'.
Is this even possible to do?
Help Article Resources
Check out the Formula Handbook template!