Microsoft Office Forums Assign different resources with different colors to the same task

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-27-2014, 03:22 AM
Shir Shir is offline Assign different resources with different colors to the same task Windows 7 64bit Assign different resources with different colors to the same task Office 2010 64bit
Novice
Assign different resources with different colors to the same task
 
Join Date: May 2014
Posts: 4
Shir is on a distinguished road
Default Assign different resources with different colors to the same task

Hi,


Does anyone know how to assign two resources for the same task BUT with different colors.
I know how to assign two resources for the same task and I also know how to color resources by raising flags BUT for some reason I can't do those two actions togheter.

Will appreciate your assistance.

Thanks,
Shir.
Reply With Quote
  #2  
Old 05-27-2014, 08:25 AM
JulieS JulieS is offline Assign different resources with different colors to the same task Windows 7 64bit Assign different resources with different colors to the same task Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

In the bar styles dialog box, use bars that do not overlap. See the attached picture. For Pete's bar style I picked a narrow bar that only occupies the top of the row. For Mary's bar style, I picked a narrow bar that only occupies the bottom of the row.
Attached Images
File Type: jpg bars.jpg (261.0 KB, 13 views)
Reply With Quote
  #3  
Old 05-28-2014, 01:48 AM
Shir Shir is offline Assign different resources with different colors to the same task Windows 7 64bit Assign different resources with different colors to the same task Office 2010 64bit
Novice
Assign different resources with different colors to the same task
 
Join Date: May 2014
Posts: 4
Shir is on a distinguished road
Default

Thank you Julie!
I just notice that I have an issue with the Flags of the two resources, for some reason once there are two resources for the same task both Flags are turning to be "NO".
Maybe you can share with me the all process from A to Z from assigning two resources till color them differently.

I truly much appreciate it!!

Thanks,
Shir,
Reply With Quote
  #4  
Old 05-29-2014, 05:38 AM
JulieS JulieS is offline Assign different resources with different colors to the same task Windows 7 64bit Assign different resources with different colors to the same task Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

For each Flag field you will need the following formula:

IIf(InStr([Resource Names],"r1")>0,-1,0)

replace the "r1" with each resource name - enclosed in quotees.

The formula tests the location of the resource name inn the Resource Names field. If that location is greater than zero, it displays Yes, if it is zero or less, the name does not exist within the field. Using the InStr formula allow multiple resources to be assigned.
Reply With Quote
  #5  
Old 05-29-2014, 08:41 AM
Shir Shir is offline Assign different resources with different colors to the same task Windows 7 64bit Assign different resources with different colors to the same task Office 2010 64bit
Novice
Assign different resources with different colors to the same task
 
Join Date: May 2014
Posts: 4
Shir is on a distinguished road
Default

Thanks Julie,
But now I can see both colors together (same as in your print screen) even though I have scheduled the two resources to start one after another and I expect to see this diffrentiation in the colors as well.
any idea how i can do this?

Thanks again!
Reply With Quote
  #6  
Old 05-29-2014, 05:08 PM
JulieS JulieS is offline Assign different resources with different colors to the same task Windows 7 64bit Assign different resources with different colors to the same task Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

To the best of my knowledge, that is not possible. The bars run from task start to task finish - not from assignment start to assignment finish.

If the second resource's work is dependent upon the first resource's work - I suggest splitting the task in two and assigning each resource to his/her part.
Reply With Quote
  #7  
Old 05-31-2014, 11:04 PM
Shir Shir is offline Assign different resources with different colors to the same task Windows 7 64bit Assign different resources with different colors to the same task Office 2010 64bit
Novice
Assign different resources with different colors to the same task
 
Join Date: May 2014
Posts: 4
Shir is on a distinguished road
Default

The resources don't depent each other, it just I have multiple small projects (that I refer to them as different tasks) that each one of them needs only 2 resources that scheduled one after another. I am trying to find a way to assign both resources for each project without spliting each project into two lines.

Is it possible?

Tnx,
Shir.
Reply With Quote
  #8  
Old 06-01-2014, 08:22 AM
JulieS JulieS is offline Assign different resources with different colors to the same task Windows 7 64bit Assign different resources with different colors to the same task Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Yes, you can assign multiple resources to work on the same tasks at different times. You must edit the assignment start and end times in the Task Usage view or the Task Form showing the schedule. However, you cannot display different colored bars for each assignment start and end time - only for each task start and end time.
Reply With Quote
  #9  
Old 04-21-2017, 12:15 PM
sekmet7@gmail.com sekmet7@gmail.com is offline Assign different resources with different colors to the same task Windows 10 Assign different resources with different colors to the same task Office 2010 64bit
Novice
 
Join Date: Apr 2017
Posts: 1
sekmet7@gmail.com is on a distinguished road
Default Formula for Color Coded Resources Based on % used.

I posted to this question because it was helpful to see the formula for that assigned 2 colors to a task with 2 resources. Thank you!

Now here is my question - does anyone have a formula that will allow multiple different resources to be assigned to a single task but display the color (via flag) for the resource with the greatest % allocated? I am using Project 2010 & when I assign more than one resource the flag stops working.
Reply With Quote
  #10  
Old 05-05-2017, 12:29 PM
JulieS JulieS is offline Assign different resources with different colors to the same task Windows 10 Assign different resources with different colors to the same task Office 2016
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Unfortunately, no. The formula works on a task field [Resource Name]. Assignment units is not a task value, but an assignment value.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Assign different resources with different colors to the same task Task types with no Resources assigned mtaylor Project 1 05-24-2014 12:37 PM
Assign different resources with different colors to the same task Cannot type in the cost field of the assign resources dialogue box cldonley Project 1 02-05-2014 07:42 AM
Excel cannot complete this task with available resources. Choose less data or close YounesB3 Excel 1 11-16-2012 02:40 PM
Assign different resources with different colors to the same task excel cannot complete this task with available resources - vlookup Taisho Excel 4 01-27-2012 03:09 AM
Assign different resources with different colors to the same task How to set task to be done by 4 resources each one after another? lukusm Project 1 01-16-2012 07:21 AM


All times are GMT -7. The time now is 04:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft