Hi Coda Community!
I am trying to build a roster view in a Gantt chart for our team. We operate on a ‘swing’ basis which means we have team members who alternate.
I want to demonstrate on a Gantt chart when each team member is ‘on’ their swing and who is filling that position so any team member can quickly and easily see who is filling that role. You can see I have had a go at this a little with not much luck at this doc:
(feel free to comment edit - if you can assist with the below)
Team and Contacts - This is a table with names and their roles. (DATA)
Roles - This is a table with the roles of all the team. (DATA)
Swings - This is a difficult one I am not sure how best to structure and seeking your advice.
This demonstrates the start and end dates of each member of the team, the duration of time they are on and the duration they are off, grouped by role and individual, with some formulas.
I have used ‘Relation’ function to draw names and roles and grouped by Roles. I think this is right? Not sure what the best reference column should be? (currently ‘Name’).
Q: You will see that swings are structured by days on and off. How can I automate/create rules this so I don’t need to manually add every start and end date, even though I have automated this somewhat with formulas. This is very structured so once you know the start, duration, end date, and off days, you could essentially just flow out the whole thing ad infinitum.
Q: Is separate line items the best way to show this considering the rostering format I want to achieve (see below)?
Roster - This is the difficult one. A timeline of the roster - ideally I want it to have a line for each team member grouped by position (as is currently the case), but not multiple lines for each swing.
Q: See how PW/JS has two rows? Is it possible to make that one? so you can just see when that individual is coming on and off their swing?
Any other suggestions for how best ot build this?
Q: Also as a general admin question about Coda, is there a way of standardising date formats to UK standard (ie 31/1/2023) so I don’t have to change it for every column I create. At Account and/or Document Level?