Hello Diana,
You could add the following to the evaluation criteria: $EntityType = "Task"
I hope this helps.
Roland
Comment actions
Post
Follow
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?
Please sign in to leave a comment.
6 comments
Date
Votes
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?
Comment actions
Hi Diana,
Yes, that is correct. Use && between multiple conditions.
Roland
Comment actions
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"?
Comment actions
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
Comment actions
Perfect. Thank you, Roland!
Comment actions