Ticket Tracker | Escalation steps after x days | days vs workdays

Joerg Schmidt

Hi,

hope you can help me again with this issue?

We build another ticket system f.e. for new letters coming from various authorities. Depending on importance we want to escalate the working process and send reminders to supervisors f.e. after 2/7/14 days

But we need to set working day instead of normal day into the automation.

Example: If somebody submits the form on Friday the escalation would be on a Sunday-

Is it possible to tell Smartsheet it shall be the next working day not day ?

Eskalation_workdays.png

Andrée Starå

Hi @Jörg Schmidt Novum Hospitality

I hope you're well and safe!

I'd recommend adding a so-called helper column referencing the submission date and then use the WORKDAY function.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

My suggestion would be a date column with a formula that outputs the correct date and then have your automation run on this new column.

Andrée Starå

Hi @Jörg Schmidt Novum Hospitality

I hope you're well and safe!

I'd recommend adding a so-called helper column referencing the submission date and then use the WORKDAY function.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!