Forum Discussion
- MCFNeilQrew CaptainNatively and Perfectly, no.
But here is a sneaky workaround for another option.If(Rem([Record ID#], 2)=0, "#EvenColor", "#OddColor")
This will basically will devide the record id by 2 and if there is no remainder, then it will color one, or the odd color.
It works as long as you have one of the sorting things to go by record ID, first or last.
Or if you have some field that sequentially grows you can use that as well.
Just Ideas.- GauravSharma3Qrew CommanderGreat! Love your skills Buddy :) :)
- Eric_J_HansenQrew CadetMatthew - this is brilliant in its simplicity. Love it. =]
- PeterDisneyQrew MemberHi there, 2 questions - can you colour rows dependent on the resource (assigned to) using a variation of the above? Secondly, where do you put the code??
- GauravSharma3Qrew CommanderHi Peter,
Just customise the report and put the code in the row colorization under the Record highlight option.
Please let me know if you need any further help.
Thanks,
Gaurav - PeterDisneyQrew MemberThanks - any clue on how to code a colour change for each different assigned to record?
- PeterDisneyQrew Memberalso - seems no area for coloration on timeline report :-(
- MCFNeilQrew CaptainIf your "assigned to" resource is via a relationship,...
Create a new field on the resource table, call it something like [Color]
Put the custom color hex (#xxxxxx) there, then pass that value to the main table (tasks or jobs, whatever you have it called).
Then in the report settings you can select the checkbox for 'colorization' towards the bottom, the simply insert that new lookup field [Resource - Color]- GauravSharma3Qrew CommanderActually, peter is using timeline report and there is no option for colorization. :)