Skyhaze001
New Member
- Joined
- Dec 7, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi, I have a spreadsheet that tracks internal quality issues with the following key cells:
Column A - date identified
Column G - Critical/Major/Minor
Column J - target close out date
Is it possible to auto-populate J with a date depending on the option selected in G? For example the target close out for a critical issue is 7 days after being identified so J should be A+7 days. Major should be A+14 days and minor should be A+30 days
Column A - date identified
Column G - Critical/Major/Minor
Column J - target close out date
Is it possible to auto-populate J with a date depending on the option selected in G? For example the target close out for a critical issue is 7 days after being identified so J should be A+7 days. Major should be A+14 days and minor should be A+30 days