Trigger a Checkbox when the System time matches a Service Level Time

Allan Moyo

Our internal customers can submit requests to expedite a process to meet a customer's deadline. These requests should be processed within three hours of receipt.

Currently, I can add three hours to the creation date and time to fill in a Max SLA Field. Once that future time (Max SLA) is reached (matches the system time), I need to trigger a checkbox to initiate the next steps. This involves checking the status of the request and either notifying the agent's leader if the request has not been addressed or taking no further action if the request has been resolved. I found some threads around the topic of "Time", but the formulas didn't seem to work for me. I appreciate all the assistance that I can get. Thank you

kowal

@Allan Moyo what about this one

https://community.smartsheet.com/discussion/107768/setting-automations-based-on-time-in-a-cell

Paula Grahame

We have a sheet looking up a match reference from another sheet and auto checking a box. Perhaps a similar formula would work for your scenario?

=IF(COUNTIF({REFERENCE SHEET HERE}, [Matching 2nd reference here]) = 1, 1)

kowal

hi @Allan Moyo,

can you show me the piece of the time stamp you are trying to make the formula based on and the formula itself?

Allan Moyo

Hi @kowal ,

Yes, happy to. We are using the default create date to add Service Level agreements based on the type of request that is submitted. Requests need to be addressed in 1, 2 or 3 days. The SLA update is when that task is due. What I would like to do is trigger the SLA Time Checkbox once the system time matches the SLA Update time. Below I am using a Modified time but its not quite I am looking for.

Thank you

Allan Moyo

@Paula Grahame thank you for taking the time to review my question. I appreciate the help.

I hope the post above clarifies what I am attempting to resolve.

kowal

@Allan Moyo,

I did some test so it's possible to create date & time very easily like 3h after Date Created the problem is with triggering any workflows (as those can be triggered only on defined time) and if it goes for formula there is not such formula like … =now() it's only =today() so even if you have

Allan Moyo

Thank you @kowal , I appreciate you taking the time to look into my question. You ran into the same issues as I did. I welcome suggestions on a different approach if there is one.

kowal

@Allan Moyo what about this one

https://community.smartsheet.com/discussion/107768/setting-automations-based-on-time-in-a-cell

Allan Moyo

Thank you @Kowal, I think that may just work.

It's a long way around but that may work. Thank you so much for the prompt responses and support.

kowal

sure, always pleasure.