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.

Best Answer

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓

    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), "")))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!