Dashboard widget flexibility

swaldon2

Hello

Is there top show a subset of tasks from a project plan on a dashboard and ONLY have the end date filled in once marked a 100%? I made a report of the subset of tasks but I am unsure if it is possible to not include the date until it is 100%. Maybe a report is not the solution, but if there is a way to do this report or not please let me know!

JamesB

@swaldon2

The End Date column is needed for your project. I would suggest you had a helper date column to your sheet and use a formula to populate it.

=If([% Complete]@row<>1," ",[End Date]@row)

Then on your report you can use this column and not the end date column.