Understanding Statistical Distributions.Area, Surface Area and Volume Reference Sheet.Simple Transformations of 2-Dimensional Shapes.Polar, Cylindrical and Spherical Coordinates.Introduction to Cartesian Coordinate Systems.Introduction to Geometry: Points, Lines and Planes.Percentage Change | Increase and Decrease.Mental Arithmetic – Basic Mental Maths Hacks.Ordering Mathematical Operations - BODMAS.Common Mathematical Symbols and Terminology.Special Numbers and Mathematical Concepts.How Good Are Your Numeracy Skills? Numeracy Quiz.Then I tried to do the SUMIF again, it still shows up as 0. I've tried to make the Capacity column format as percent by highlighting the entire column and hitting the % symbol on the task bar. I have no idea why this is so hard for me! But here's what I did trying to follow the directions you gave: Let me know if this makes sense, or if I've misunderstood your question! Then at the top of this column you could use a SUM function and it will work on the numbers, now! You could also do SUMIF statement if you only wanted to sum the percent based on one specific Project Manager, referencing this helper column so it has numerical data to sum. You can then format the column as a % and it will adjust this. This formula will return a decimal in the Total Percentage column. this is why I added the additional IF statement rule at the beginning. Since the LEFT function is only grabbing the 2 numbers on the left of the cell, if the value is actually 100 it would read it as 10. You could either re-write this formula with decimals, or you could use a formula in that Total Percentage column that looks at the value in the Capacity column in its row and return the numeric version: Percents in formulas need to be written as decimals in order to be identified as numerical ( see here), then the Capacity column would be formatted to add in the % sign. I think where you may be having issues is that the percent is being returned as text, since in your Nested If you have "50%" written in the formula. Text appears on the left, whereas numerical values appear to the right. You can tell if it's working because the numbers should appear on the right of the cell. My apologies, I should have been more clear! Adding the quotation marks around the decimals treats it as text again, so it won't format properly. I hope I explained this in a way that makes sense! Sort of a more involved/complicated way of doing resource management. Then using sheet summary take all the individual project manager data with their total percentage of capacity and visualize it with a dashboard. Each project manager will have their projects sorted by their email address and the total percentage will be calculated somehow. In a perfect smartsheet world we want to have our sheet with all active projects and the columns PME, PCR, Capacity and total percentage. It needs to be automated as much as possible otherwise it needs to be manually updated and it defeats the whole purpose. We are trying to find a way through smartsheets to automatically calculate how much capacity each individual Project Manager is operating under and visualize all the data in a dashboard. The point is that I will eventually add these columns to a larger sheet with all active projects. The percent value is being calculated with the Nested IF formula that I have shown. I'm trying to figure out a way to add the percentages from the Column labeled "Capacity" with a function and have them automatically tally together in the "Total Percentage" column.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |