#1
|
|||
|
|||
MSP 2013 - A new column needed a bit like resource names
(Sorry for the weird title - newbie here )
Ok, when you have the resource column, you can tick more than one resource for each task, ie I can have Chas on one task, Dave on another and have Chas and Dave working together on others. This is great. I am scheduling works between different buildings, and have a Text column that I renamed to "Building". So far it has been one task, one building, straightforward. So one task is in "The Character Building" another task is in at "Circle Square". Now, one of my (recurring) tasks is to be done in seven buildings on the same day so rather than repeat the task 7 times, I've put it in once, and in the buildings column wanted to have all 7 buildings named / ticked -(similar to how you would if you were assigning resources). So these tasks need to have "The Character Building" and "Circle Square" in the "building" column. Hope this makes sense, and is this even possible please? |
#2
|
|||
|
|||
Sorry, no. There aren't any other multi-value fields in Project like the Resource Names field.
|
#3
|
|||
|
|||
Ah, thanks for the reply.
I don't know how to tackle this then. At the moment, I've got one recurring task with Dave as the resource name and all the buildings separated by columns in the Building (text) column. Hopefully this will suffice and when I need to print a particular buildings jobs, I will have to remember to filter for that building AND the one with multiple buildings in it. Either that or do a separate recurring task for each building, which I wanted to avoid as it could get unwieldy. Thanks for the reply though, I'll see how it goes. |
#4
|
|||
|
|||
Hi Peasy,
The issue is going to be what reports you print. If the building data is in a text field (which it sounds like it is) you should be all set with printing from a task view or task report. The problem will come if you try to look at the data in the Resource Usage view, for example. Task data does not appear in the Resource Usage view - only resource and assignment data. You can certainly type the multiple building names in the text field as it does allow multiple values to be typed in - but when filtering you'll need to use a "contains" instead of "equals". |
#5
|
|||
|
|||
Quote:
Thank you |
#6
|
|||
|
|||
You're welcome. Post back with further questions as needed.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Resource Usage View - Is it possible to display resource names | Andrea Schanz | Project | 6 | 09-22-2014 07:47 AM |
Field name with Resource Names | Puddlerunna | Project | 3 | 09-02-2014 05:58 AM |
Parsing 'FullName' column - help needed text to column | ScottA | Excel Programming | 3 | 05-06-2014 12:49 PM |
matching names in column A with names in column C | bob999999 | Excel | 1 | 04-28-2013 11:21 AM |
How to enter names in Resource Pool/names | pstein | Project | 1 | 03-26-2012 07:37 AM |