Complete Yes or No field

[JonBsan]

Hi,

I'd like to create a field that would show yes only if a task is 100%
complete. I can do this by adding a text field and manually entering yes or
no based on completion, but I am hoping there is an automated way to generate
the yes or no. I am doing this so I can export task lists to owners who do
not have MSProject in an easy to read spreadsheet.

Thanks for any help!

 

[Jim Aksel]

In a spare test or flag field, add a formula:

iif([Status]="Complete", "yes","no")
You could also use [PercentComplete]="100" but if you change methods of EV,
then you would have to change the formula.

To insert a formula, insert the desired text or flag column, right click on
it, then select "Customize Fields" then select formula. It is pretty
intuitive from there.

What we would do: Use the AutoFilter, select 100% from the drop down and
then print the file to a PDF.
--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

 

[JonBsan]

That worked great, using PercentComplete. Thanks much!

Jon

In a spare test or flag field, add a formula:

iif([Status]="Complete", "yes","no")
You could also use [PercentComplete]="100" but if you change methods of EV,
then you would have to change the formula.

To insert a formula, insert the desired text or flag column, right click on
it, then select "Customize Fields" then select formula. It is pretty
intuitive from there.

What we would do: Use the AutoFilter, select 100% from the drop down and
then print the file to a PDF.
--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

Hi,

I'd like to create a field that would show yes only if a task is 100%
complete. I can do this by adding a text field and manually entering yes or
no based on completion, but I am hoping there is an automated way to generate
the yes or no. I am doing this so I can export task lists to owners who do
not have MSProject in an easy to read spreadsheet.

Thanks for any help!