How do I calculate different due dates on actions depending on the type of action?
I have created a sheet in which different type of issues are identified and assigned to owners. I have established three "observation types" that I would like to assign different due date. For example, a safety issues would need a due date of 2 working days from the date identified, and an Opportunity to Improve action would need a due date 14 working days for the date identified. Any help would be appreciated. Thank you.
Help Article Resources
Check out the Formula Handbook template!