Auto set Due Date based on the ticket Issue Type

(Applies to: SharePoint Online)


– Create a single line of text column “Time Span” in Issue Type list and configure it for the Issue Types in DD:HH:MM:SS format.

For example, if  Due Date should be auto set as "4 Days 3 Hours 32 Minutes" after ticket creation, configure "Time Span" in Issue type as 4:3:32:0

Workflow configurations:

– Go to Crow Canyon Workflow Manager app and configure a workflow on tickets list item created event.

(Optional) Delay Execution can be configured in the workflow to avoid conflict with Product app and other workflows present on tickets list.

– Create an "Update Item" like shown below.


Field mapping of "Due Date" will be like: $calcbusinesstime([Created|Created],[Issue Type::Time Span|IssueType::Time_x0020_Span])

(Select "Created" and "Issue Type::Time Span" columns from the left list box and use "Add Place holder to value" during this configuration).

This calculation will exclude the non-business days.

– To include Saturday/Sunday as business days, go to Site Settings –> Regional Settings and define the Work Week.

Leave a Reply