Report - List Type - Conditional Formatting

Jones
Giga Contributor

Is there a way to utilize conditional formatting for a report - list type?  I understand that I can use the "Styles" area of the other types of reports but from what I can see it is very difficult to get the report out in the format i'd like otherwise.  I have a report that pulls a list of tasks and then reports out the Planned Start Date and Due Date.  I'd like to have a conditional format that makes the Planned Start Date turn red based on being past the due date.  This is being put into a dashboard widget for key stakeholders. 

 

find_real_file.png

5 REPLIES 5

Adam Stout
ServiceNow Employee

Jones
Giga Contributor

No I have not.  I am not an admin however I believe I could get the personalized_Styles role.  Would there be a way of ensuring that this field style does not end up being a universal field (i.e. if i implement this on a variable used on other projects and programs will it also change that variable for everyone else or just my reports)

Hello Adam,

 

if you can help me on this, the options given to condition the Field with Red Color based on some condition, if the Planned state date has passed, is not working for me. Either I am missing something or step.. 

 

Please help. 

 

Scenario: I have a report which list the Task to be completed by the user. However all tasks are in default color. Expectation, if the Planned Start Date is 

1. Greater than 1 week - Defult Color

2. within 3-4 Days - Yellow Color

3. Passed the Start Date -RED 

 

 

DirkRedeker
Mega Sage

Hi

Why don't you create a report on showing only the "red ones".

That way, the user does not search for data, based on style.

The user will know, that all records shown are in that "red" status.

I recommend to create a specific extra report for that.

Think in terms of purpose when creating reports, instead of trying to create "one for all" reporting.

This may satisfy your end users more.

Let me know if that answered your question and mark my answer as correct and helpful.

BR Dirk