Meeting SLA Formula

Lorraine Stevens

Hi there!

I'm working on an SLA formula. The "Approve/Decline Date" must be within 4 business days of the "Request Received" date. The formula is in a helper checkbox column. I will then use this to calculate the % of events that meet the SLA for each team member. I am stuck on how to note 'business days' in the checkbox formula. How can I incorporate 'WORKDAYS' in this?

=IF([Approve/Decline Date]@row - [Request Received]@row <= 4, 1, 0)

Thank you for the help!

Paul Newcome

You would need to use the NETWORKDAYS function.

https://help.smartsheet.com/function/networkdays