|I hope I can explain this right.|
In column F I have a drop down list for each cell within that column so users can pick the correct classification out of:
Minor (5 working days)
Moderate (10 working days)
Major (15 working days)
Severe (25 working days)
In column G I want to add a formula that will automatically input the date the response is required by which is determined by which classification is picked.
The date the complaint/comment received is logged in column A.
Can anyone help with this please? Is there such a formula?