Column to show if actual hours exceeds planned hours

[ScottSm]

Morning everyone, I've been scouring the support forum but failed to find what i was looking for so thought i'd jump on and ask. I have projects that are converted which cover several teams. Within these projects are several tasks whereby i want to see if a tasks (allocated to my team) have been completed within the expected SLA. The tasks have 'planned hours' and my team log their hours, which i believe populates the 'actual hours' field automatically once logged. What i'm looking for is to have a task report, with a column header labelled up as 'In/Out of SLA' which calculates the planned vs actual, and shows 'Inside SLA' or outside SLA' respectively. This will then allow me to understand if we're achieving our team goals of delivering for the wider business effectively. I hope that someone can help with an IF, Greater than formula to help me 🙂 Thanks Scott Smith Senior Producer UNiDAYS

[Doug_Den_Hoed__AtAppStore]

Hi Scott, I'd suggest a calculated text parameter called SLA Status with a formula (untested) of something like: IF(Actual Hours > Planned Hours,"Red", IF(Planned Hours - Actual Hours > 4,"Yellow","Green")) By then coloring the column accordingly, you can visually indicate when it's over, getting close (eg within 4 hours), or is still ok. Regards, Doug [DDH: formula corrected after initial post] Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

[ScottSm]

Hey Doug, I'm new to calculated expressions so may need a little hand-holding on this one. I've added a column in my report and added the following in text mode: displayname=SLA Status textmode=true valueexpression=IF(Actual Hours > Planned Hours,"Red",IF(Planned Hours - Actual Hours > 4,"Yellow","Green")) valueformat=HTML however the column is blank when viewing the full report Scott Smith Unidays

[Doug_Den_Hoed__AtAppStore]

No worries, Scott, In the interest of Teaching You To Fish, I'd invite you to review "https://support.workfront.com/hc/en-us/articles/360001028853-Understanding-Common-Uses-of-Text-Mode">Understanding Common Uses of Text Mode . The textmode I'd suggested originally was intended for a Calculated Custom Field, and (if I'm following) what you're attempting is to use textmode in a View. For better or worse, there are slight differences in syntax (which the article above explains), but one you are aware of them, you can choose whichever best suits your needs. Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads