How do I calculate different due dates on actions depending on the type of action?

dminor764

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.

Carson Penticuff

This is going to be the general idea. You will want to replace the name of the column that you use for the date of the observation. I also didn't know the name of the third observation type or the time period.

=IF([Observation Type]@row = "Safety", WORKDAY([Observation Date]@row, 2), IF([Observation Type]@row = "Opportunity to Improve", WORKDAY([Observation Date]@row, 14), IF([Observation Type]@row = "Other Type", WORKDAY([Observation Date]@row, 365), "")))

Carson Penticuff

This is going to be the general idea. You will want to replace the name of the column that you use for the date of the observation. I also didn't know the name of the third observation type or the time period.

=IF([Observation Type]@row = "Safety", WORKDAY([Observation Date]@row, 2), IF([Observation Type]@row = "Opportunity to Improve", WORKDAY([Observation Date]@row, 14), IF([Observation Type]@row = "Other Type", WORKDAY([Observation Date]@row, 365), "")))

dminor764

Thank you! That is perfect!

Carson Penticuff

I'm glad I could help!