Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 04, 2022 09:03 AM
We need to plan and follow up our teams on a weekly basis.
Or we do it with start-end dates (but then we need multiple lines for the same person) Or we create a column for every week (see screenshot). Not the best database-design, but it works for now.
also for creating totals… it’s quite challenging (W01+W02+…W52)
Are there better solutions to tackle this ?
Apr 07, 2022 01:07 AM
Hi @Kristof_Vandenbogaer and welcome to the community!
You could add a single date field (manually filled or eg a “created time” field) to every record and create a formula field that gives you the week number. You can then group by that field.
Use:
WEEKNUM(date)
Apr 07, 2022 02:25 AM
At this moment I have 52 (week)columns where we can give the percentage planned of the employee.
Alternative is that we use a new record for every project/employee/task with a start-end date, but this gives us not the visibility and the flexibility to do a planning on a weekly base.
. This is a far better database model, but it has not the same user interface flexibility. People are used to fill in an Excel, and fill the % in every week. Very effective, but less OK Database structure…
The disadvantage of our method is that we can’t create a timeline/gant/chart or other “easy” reporting tools.
Apr 07, 2022 05:03 AM
Choosing is losing, but I would use a database tool as a database, and not a wannabe Excel for UX reasons. Personal thought of course :slightly_smiling_face:
Apr 07, 2022 05:43 AM
I agree…
But you don’t want to manage 250 people with 20 managers who will need to fill in a new record for every week of every task… just not manageable
(but that’s a scaling problem. Tbh the way we have implemented it now works very fluent, but we need some extra backend-workarounds to get our reporting and I was wondering if there were better setups)
Apr 07, 2022 05:59 AM
Automations could help creating recurring tasks. Maybe that could be something to explore?