custom columns for WKS
in [Project]
|
From: Penny on 26 Jan 2010 16:16 I would like to create a formula in a custom field that tells me what week my start date is in. I have my gantt set up to show WK1, WK2, etc. I would like to have that same week designation in a custom column. Can I do that? thanks. Penny
From: Andrew Lavinsky on 27 Jan 2010 00:14 I don't have a copy of MS Project available at the moment, but in theory, you could create a custom text field using a formula like the following: "WK" & Round(ProjDateDiff([Project Start],[Start])/(5*[Minutes Per Day]),0) ....or something like that. I'd have to test it in Project to make sure the syntax is correct. I'd also have to assume the project started on a Monday - otherwise, some of the results may be a bit skewed. "Penny" wrote: > I would like to create a formula in a custom field that tells me what week my > start date is in. I have my gantt set up to show WK1, WK2, etc. I would > like to have that same week designation in a custom column. Can I do that? > > thanks. > > Penny
From: Jim Aksel on 27 Jan 2010 02:14 Andrew has it with one additional thing... "WK" & Round(ProjDateDiff([Project Start],[Start])/(5*[Minutes Per Day]),0) +1 You need to add the 1 at the end becuase the ProjDateDiff function returns 0 for the week containing the project start date. So it is a "0 base offset" in geek terms. The formula works fine regardless of start date day of week. Thanks Andrew! -- If this post was helpful, please consider rating it. Jim Aksel, MVP Check out my blog for more information: http://www.msprojectblog.com "Penny" wrote: > I would like to create a formula in a custom field that tells me what week my > start date is in. I have my gantt set up to show WK1, WK2, etc. I would > like to have that same week designation in a custom column. Can I do that? > > thanks. > > Penny
From: Sai on 27 Jan 2010 04:13 On Jan 27, 2:16 am, Penny <Pe...(a)discussions.microsoft.com> wrote: > I would like to create a formula in a custom field that tells me what week my > start date is in. I have my gantt set up to show WK1, WK2, etc. I would > like to have that same week designation in a custom column. Can I do that? > > thanks. > > Penny Penny - Correct version of Jim Aksel works. If you would like to change your timescale (by default, the top tier displays the week start date -- Feb 7 10, and bottom tier displays weekdays -- S, M, T, ...), to displays the week numbers instead, then follow the below steps 1. SelectFormat, Timescale 2. Select Middle Tier, and change the Label: to W1, W2, ... Please let us know if this satisfies your requirement - Sai, PMP, PMI-SP, MCT, MCTS http://saipower.wordpress.com
From: Penny on 27 Jan 2010 09:25 Thank you very much for the feedback. I used this exact formula and was very pleased that I got mostly the results I was looking for. I was hoping to post a picture of what I got but can't. I did get the wks in the columns. But they are not exactly lining up with the wks in the gantt. What kind of adjustments do I need to make? Thanks again. Penny "Jim Aksel" wrote: > Andrew has it with one additional thing... > "WK" & Round(ProjDateDiff([Project Start],[Start])/(5*[Minutes Per Day]),0) +1 > > You need to add the 1 at the end becuase the ProjDateDiff function returns 0 > for the week containing the project start date. So it is a "0 base offset" > in geek terms. > > The formula works fine regardless of start date day of week. > > Thanks Andrew! > -- > If this post was helpful, please consider rating it. > > Jim Aksel, MVP > > Check out my blog for more information: > http://www.msprojectblog.com > > > > "Penny" wrote: > > > I would like to create a formula in a custom field that tells me what week my > > start date is in. I have my gantt set up to show WK1, WK2, etc. I would > > like to have that same week designation in a custom column. Can I do that? > > > > thanks. > > > > Penny
|
Next
|
Last
Pages: 1 2 3 4 Prev: how do i reset the Unique ID field in Project 2003? Next: Macro for filter |