Quote:
Originally Posted by ArviLaanemets
A possible solution in edited workbook.
Added a calendar table and a calculated column into 1st table.
Btw, having a table you add a new column per week is a waste and after some time will be cumbersome! Why not design a report sheet, where you select a week (you can use data validation list), and a table for this week is filled (list of active employees in column A, list of active streams at top, and percents in table, plus additional column for person total).
|
thanks for the reply, that second option you mentioned sounds interesting, what should I research to work on that solution?
in the meantime I will look at the spreadsheet you uploaded.