Looking for formula
need to populate a date with these parameters.
Defect type ="CRITICAL" - populates "clean up date" with date 5 days after "audit received date"
but if Defect type = "major" or "minor" - populates "clean up date" with date 30 days after "audit received date"
right now i have simple formula to populate Clean up date as 30 days after audit date. But the defect type changes that date parameter to 5 days out instead of 30 days out. Is there formula to do that, maybe IF?
Help Article Resources
Check out the Formula Handbook template!