produce a report.

andrewpm

Hello, ive been asked if we can produce a report with the percentage done column like the illustration shown below?

Mike Wilday

At this time the closest you can get is to create a new symbol column using the progress bar and apply a formula like this:

=IF([% Complete]2 < 0.25, "Empty", IF([% Complete]2 < 0.5, "Quarter", IF([% Complete]2 < 0.75, "Half", IF([% Complete]2 < 1, "Three Quarter", IF([% Complete]2 = 1, "Full")))))

Sadly, there is nothing that will show you accurately the percentages... there is not 33%, 44%, its only empty, quarter, half, three-quarters and full.