Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

Column to show if actual hours exceeds planned hours

Avatar

Level 1
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
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

3 Replies

Avatar

Level 10
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

Avatar

Level 1
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

Avatar

Level 10
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