Meeting SLA Formula

Options

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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!