Difference Between “Met SLA” and “On Time or Late” Fields | Community
Skip to main content
R
RathikaCh
July 21, 2025
Solved

Difference Between “Met SLA” and “On Time or Late” Fields

  • July 21, 2025
  • 2 replies
  • 341 views

Hello, 

Hi all,

I’m looking for clarification on the difference between the “Met SLA” field and the “On Time or Late” field Workfront.

  • What’s the key distinction between these two fields?

  • What are the intended use cases for each?

What does this formula mean on the 'On Time or Late' field?

IF(!ISBLANK(CLEARTIME(Actual Completion Date)), IF(CLEARTIME(Actual Completion Date)<CLEARTIME(Planned Completion Date), "Early", IF(CLEARTIME(Actual Completion Date)>CLEARTIME(ADDWEEKDAYS(Planned Completion Date, 1)), "Late", "On Time")),"")Formula:IF(!ISBLANK(CLEARTIME({actualCompletionDate})), IF(CLEARTIME({actualCompletionDate})<CLEARTIME({plannedCompletionDate}), "Early", IF(CLEARTIME({actualCompletionDate})>CLEARTIME(ADDWEEKDAYS({plannedCompletionDate}, 1)), "Late", "On Time")),"")

 

What does this formula mean on the ' SLA Met' field?

Compares Actual Duration To Template Duration (SLA) IF((SUB({template}.{durationMinutes},{actualDurationMinutes}))>-1440,"True","False") 1440 minutes in a day to account for time zone.Formula:IF((SUB({template}.{durationMinutes},{actualDurationMinutes}))>-1440,"True","False")

 

Thank you in advance. 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by skyehansen

Ultimately I think this is a conversation you need to have with the system admin of your Workfront instance -- reading between the lines, your question is more in line with "do we need both" and that's not for the community to say.

 

I used AI to drill down on the difference between the two, which is something I frequently do in order to not have to read too deeply into formulas. So in general copilot says that your formulas are focused on timing vs duration and tracks deadline (early/on time/late) vs performance (effort vs plan)

2 replies

skyehansen
Community Advisor
skyehansenCommunity AdvisorAccepted solution
Community Advisor
July 21, 2025

Ultimately I think this is a conversation you need to have with the system admin of your Workfront instance -- reading between the lines, your question is more in line with "do we need both" and that's not for the community to say.

 

I used AI to drill down on the difference between the two, which is something I frequently do in order to not have to read too deeply into formulas. So in general copilot says that your formulas are focused on timing vs duration and tracks deadline (early/on time/late) vs performance (effort vs plan)

    RowvillBh1
    RowvillBh1
    Level 5
    July 23, 2025

    Hi @rathikach 

     

    It seems like “On Time or Late” is calculating the difference between when a task was planned to be completed vs when it was actually completed. Whereas, “Met SLA” is calculating the difference between the task's actual duration (actual time it took to complete the task or project) vs the planned duration of the template task (Duration of the same task as per the template it came from).

     

    “On Time or Late” could be used to understand whether a task was completed on time or not

    “Met SLA” could be used to understand whether a task was completed in the same duration as was set out in the template it originated from.

      Terms & ConditionsAccessibility statement

      Loading footer...