i have a formula for a custom task field:
IIf([Number2]=4,IIf([Finish]<now()-14,"Yes","No"),"No")
is there a way to manipulate the above formula to also check whether it's a summary task?
thanks
-hisbad
sorry for the ambiguity...
version 2003 standard.
I populated the resource sheet using the wizard that grabs the names from Outlook.
So when I am in the Gantt cgart view I use the Resource Names column to add a resource to a task.
I would also like to have "Text1" (in the task row) to pull...
I am using the Resource field that is populated from the Resource sheet.
However, I have a custom text field (Text1). I want the drop down values in Text1 to be the names in the Resource sheet as well.
It's not available in the Import Values option
It's not available as the formula
I can't...
The only problem with IsItTheRightFormula = "Stop Cheating You Little Toads"
is.. if they try to get it right, i mean they really really try, and they get it wrong, you're still caling them a cheat.
-hisbad
when you have the Define Name box open, at the bottom there is a 'Refers to' field. in that field you should type "=GET.CELL(48,INDIRECT("rc",FALSE))" exactly as ive written it.
let me know how you get on.
this gives you a clear visible indicator.
any cell that is a formula as apposed to a number will be highlighted by whatever format you put in the conditional formatting.
i'm unsure of whatelse you want.
In MS Project...
I am using the Resource field that is populated from the Resource sheet.
However, I have a custom text field (Text1). I want the drop down values in Text1 to be the names in the Resource sheet as well.
It's not available in the Import Values option
It's not available as the...
go to Intert/Name/Define
in the Names in workbook box type "isAformula"
in the Rferes to box type "=GET.CELL(48,INDIRECT("rc",FALSE))"
then just set the condition formatting for the cells you want to check as Formula is "=isAformula
i figured it out - can't be done withut VBA (well I couldn't do it without vba!)
Private Sub Project_Change(ByVal pj As Project)
Dim ts As Tasks
Set ts = ActiveProject.Tasks
For Each t In ts
If Not t Is Nothing Then
If Not t.Summary Then t.Text11 = t.Name & " (" &...
Ken
Your answer looks a lot neater than mine even though (I think) they give the same result.
Do they have an underlying difference? IOW, When would you use one ond not the other?
Thanks
HisBad
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.