none
Tasks with Date Constraints RRS feed

  • Question

  • Hello All,

    I cannot seem to figure out the formula to enter a value of 1 in the number 1 field if a task has a date constraint.

    Can someone please advise how to accomplish this?

    Thanks for your help,

    K/R

    CharlieJo

    Monday, April 24, 2017 3:10 PM

All replies

  • Hi,

    I think you want this: "IIf([Constraint Type]=0,0,1)"

    Does that help?
    Barbara

    Thursday, April 27, 2017 4:40 AM
    Moderator
  • Thanks for your reply.

    I am using the following formula:

    IIf([Constraint Date]=projdatevalue("NA"),0,1)

    Wednesday, May 10, 2017 12:35 PM
  • Hi, personally i think Barbara's is a better answer, as the Projectdatavalue does not always evaluate "NA" correctly, esp in non-English languages.

    Ben Howard [MVP] | web | blog | book

    Wednesday, May 10, 2017 1:21 PM