Member-only story
Automatically populate next time
Determine the date and time when your SLA is due to be met
This was the question I noticed shortly in the community before it was removed.
Hi all
I’m wondering if it is possible to include/consider working hours in a formula (9am-5:30pm Mon-Fri in particular)!
I have a table to track tasks. I have a column for the date that the task is added and based on certain SLA, I want the due date & time to automatically populate.
For example, if a task has a 4 hour SLA and is created today at 9am, then the due date will be today at 1pm. I can easily set up the formula/buttons to calculate this for each task and SLA. However, I’m struggling when it comes to “stopping the clock” for non working hours. For example, if a task is added today at 3pm, I do not want the due date to show as 7pm today, I want to show as 10:30am the following working day.
I came across a question in the community that resonated with my PTO work, so I tackled it and turned it into a helpful blog post. It’s essential to lay a solid foundation with a well-organized data structure. Then, you can fine-tune your filters, and you’re practically done!
Although there are more tables, these are the two core tables in our set up.
