Forum Discussion
Custom Text and Multiple results in a cell
Good morning,
I have two questions. For context, I have built a Gantt chart which shows preconstruction work and construction work for a project using different color highlights. I would like to add functionality to this Gannt chart. I want to add two different things, the first is the numerical count of the number of workers, so if the project has 3 fabricators and 2 fieldworkers I want the cell to return both 3 and 2. I would also like for those numbers to be displayed with the custom text "Fabricators" and "Fieldworkers" I have a similar function else where in my workbook where I use multiple cells (one for fab and one for field) and SUMIFS (=SUMIFS(Table1[Avaliable Panel Shop Manning],Table1[1],"1",Table1[[Panels Estimated Finish Shop ]],">="&F3,Table1[Panels Planned Start Shop],"<="&F3)) to return the number of workers for a particular day, I essentially want to collapse those multiple cells into 1.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- Ok, So I am a little embarrassed cause this spread sheet is a mess and is very busy, but I have removed all of the PII that I could. The spread sheet is a giant calculator designed to estimate project duration to help PM plan preproduction and production activates while providing the program manger data for all ongoing project. It has two Gantt charts, a year long view and a zoomed in month long view. I am concerned with the month long view (4th tab). The Gantt part works, it highlights cells no problem. But I want to display more information in its cells. In the sixth tab I have a bar chart which uses SUMIFS to display how many of each type of worker are working at any given moment, the problem is that every worker type needs its own cell. I want my display to print all worker types and then list the number for each of them. I know it is a mess.
https://whstovall-my.sharepoint.com/:x:/p/kbaer/EWjmmop55d9AixHYXtvguK8BHjDgvUXEyfVgfzb9-sF6Bg?e=vCQHyiI have downloaded the workbook.
Could you provide a few examples of
- Which cell on which sheet you want to populate
- What the value should be based on the data in the sample workbook.
