Post

2 followers Follow
0
Avatar

Exclude Projects and Milestones from Conditional Formatting

I've set up conditional formatting on several columns to highlight those columns in a row if there's a certain resource name in the <Work Item>.Resources field.    I'd like to have this highlight only on a task level row - not on a milestone or project level row.  Is that possible?

Diana McClelland Answered

Please sign in to leave a comment.

6 comments

0
Avatar

Hello Diana,

You could add the following to the evaluation criteria: $EntityType = "Task"

I hope this helps.

Roland

Roland Pumputis 0 votes
Comment actions Permalink
0
Avatar

Great!   Thanks, Roland.   I assume that I'll need to "Switch to Advanced" to do that, correct?  I can't use the Basic conditional formatting editor to add that additional criteria, correct?

Diana McClelland 0 votes
Comment actions Permalink
0
Avatar

Hi Diana,

Yes, that is correct. Use && between multiple conditions.

Roland

Roland Pumputis 0 votes
Comment actions Permalink
0
Avatar

Roland, sorry that I keep asking basic questions, but I've tried this several different ways, and I just can't seem to get the syntax correct. 

Can you please tell me what to enter into the advanced field if I want to highlight only task rows (no milestones or project-level rows) if the resource name is either "John Smith", "Mike Jones", or "Stan Shunpike"?

Diana McClelland 0 votes
Comment actions Permalink
0
Avatar

Hi Diana,

I think it would look something like this:

$EntityType = "Task" && (Not(IsNull(GetLink("RegularResourceLink", $SYSID, "john.smith"))) || Not(IsNull(GetLink("RegularResourceLink", $SYSID, "mike.jones"))) || Not(IsNull(GetLink("RegularResourceLink", $SYSID, "stan.shunpike"))))

Where john.smith, mike.jones and stan.shunpike are usernames of the relevant users.

I hope this helps.

Roland

Roland Pumputis 0 votes
Comment actions Permalink