produce a report.

andrewpm

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

C075 - Production delivery schedule - 180530 (002) copy.jpg

Find more posts tagged with

Manufacturing

Templates

Construction

Sharing and Collaboration

Project Management

Update Requests

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Mystery added columns
I came back from vacation to find that about 20 columns, with headers but no data, have mysteriously added themselves to my Smartsheet. I created this version by using an older sheet as a template 3 years ago and streamlined by deleting a lot of excessive information tracking columns. And I use some hidden columns, so…
Unable to find team members in search function to share a sheet with
I am trying to share a Sheet, can't find some people in the search function. Why not?
Permissions not updating
I was given editing permissions this morning but when I open the sheet it still says I am View Only.