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

[RathikaCh]

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. 

[skyehansen · Accepted solution]

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]

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.