none
Adding a graphical indicator for Manually Scheduled Tasks RRS feed

  • Question

  •  

    I'm using Project Server 2012 SP1.

     

    I want to add a red flag indicator to a task when the Task Mode = Manually Scheduled Task.  The little pushpin icon in the Task Mode column really doesn’t communicate a 'warning' to my users.

     

    In Flag1, I have enter this syntax: IIf([Task Mode]="Manually Scheduled Task",True,False)

     

    However, although I have set Task Mode to Manually Scheduled on some tasks, Flag1 for all tasks still indicates, 'No.'

    Suggestions???


    Dave Shultz, PMP

    Tuesday, October 16, 2012 8:04 PM

Answers

  • Dave --
     
    Your formula is wrong.  The Task Mode field is a Flag field that contains either a Yes or a No.  Therefore, your formula in the Flag1 field should simply be:
     
    [Task Mode]
     
    Using that formula will yield a Yes or No value for every task.  If Yes, then the task is a Manually Scheduled task.  Based on this, your graphical indicator criteria should be:
     
    Equals        Yes            Red Flag indicator
     
    I just tried this and it works as intended.  Hope this helps.
     

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    • Marked as answer by Dave Shultz Wednesday, October 17, 2012 12:45 PM
    Wednesday, October 17, 2012 12:07 AM
    Moderator

All replies

  • Dave --
     
    Your formula is wrong.  The Task Mode field is a Flag field that contains either a Yes or a No.  Therefore, your formula in the Flag1 field should simply be:
     
    [Task Mode]
     
    Using that formula will yield a Yes or No value for every task.  If Yes, then the task is a Manually Scheduled task.  Based on this, your graphical indicator criteria should be:
     
    Equals        Yes            Red Flag indicator
     
    I just tried this and it works as intended.  Hope this helps.
     

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    • Marked as answer by Dave Shultz Wednesday, October 17, 2012 12:45 PM
    Wednesday, October 17, 2012 12:07 AM
    Moderator
  • Thanks, Dale.  Based on your feedback, my revised formula is IIf([Task Mode],Yes,No)

    This seems to work.  Is that the formula you used? 


    Dave Shultz, PMP

    Wednesday, October 17, 2012 1:35 AM
  • Dave --
     
    Please re-read my last post.  Your formula is still wrong.  You DO NOT need to use an IIF statement in your formula at all.  The formula simply needs to be the following:
     
    [Task Mode]
     
    Using the above formula will return a Yes or No result for each task in your Flag 1 field.  If the result is Yes for a task, that means the task is Manually Scheduled.  If the result is No for a task, that means the task is Auto Scheduled.  Using that information, set up a single graphical indicator to trap for Manually Scheduled tasks using the following criteria:
     
    Equals            Yes            Red Flag graphical indicator
     
    You are making the problem way too hard, my friend!  Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Wednesday, October 17, 2012 3:08 AM
    Moderator
  • Ahhh. Yes, less is more.  I understand now.  thx, Dale.

    Dave Shultz, PMP

    Wednesday, October 17, 2012 12:44 PM
  • Dave --
     
    You are more than welcome for the help, my friend!  :)
     

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Thursday, October 18, 2012 1:29 AM
    Moderator