Welcome!

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

Issues Opening the Sheets
I'm receiving this message every time I try to open my sheets. I'm the only admin user. I have already performed proper troubleshooting, such as clearing the cache, logging in incognito, and logging out and back in, but the issue remains unresolved. It's been a few days, and I'm unable to track our projects and this…
Adding attachments to a generated document.
I’ve created an automation that generates a document and forwards it to the individual specified in a cell. The line item also has several additional attachments associated with it. Is there a way to include those attachments with the generated document?
How to copy row values and not formulas
I have an automation set up that copies a row to another sheet each day. The automation itself works correctly, but the problem is that it copies the formulas rather than the values, which causes the formulas to break and return errors. How can I configure it to copy only the values instead of the formulas?