Sign in to join the conversation:
Hello, I need to create a health status column (RGY) that correlates to the finish date, percentage (0-100), and status (not started, in progress, complete). Please help me out with a formula because this has been so confusing.
This discussion was created from comments split from: Index Match with multiple results?.
I'm assuming that the project plan template uses a weighted average to determine % complete on the various sections of the project as well as the project overall. Does anyone know what formula is actually being used?
I have a simple workflow that copies a row to another sheet. One cell is called a Job # and is populated with a number. When it copies over, the copied version has a symbol in front of the number. Example: '8282. I checked the original cell and no such symbol was accidently put in. Does anybody know what this is and what I…