Hello, Purpose is to highlight the task request that does not come at least 3 weeks in advance. Thanks to blog entry from Kara (https://one.workfront.com/s/managed-content-blogs/workfront-wednesday-did-you-know-comparing-dates-and-more-with-conditional-forma-MCB64UAJFP6NGSFJ562WXWBB3S5Q) I got the c...
I am trying to create a calculated TASK field which displays the planned completion date of the task, and if the status of the task is complete, the background turns green. Is this even something that can be done within the calculated field or does this formatting need to be done on the report itsel...
I've got a task report that is using conditional formatting to compare 2 date fields. One of the fields is a project level custom field with no time, the other is the Planned Completion Date of the task. Both dates are present in the report so you can see in the screenshot that there are instances w...
I have a simple calculated column in my report that calculates the number of available hours left for work to be added to a monthly development release project. Once the calculation is done, I would like a negative number to color the cell RED with BOLD RED text, and a positive number to color the ...
You can use conditional formatting to quickly locate data that needs your attention, highlight specific cells in red, bolding text to make it easier to read, etc. Take it up a notch and compare fields with conditional formatting. For example, if the Actual Start Date of a task is after the Planned S...