Home

Team Calendar - Resource Availability View (JSON?)

%3CLINGO-SUB%20id%3D%22lingo-sub-708152%22%20slang%3D%22en-US%22%3ETeam%20Calendar%20-%20Resource%20Availability%20View%20(JSON%3F)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-708152%22%20slang%3D%22en-US%22%3E%3CP%3EI%20work%20with%20a%20small%20team%20of%20consultants%20who%20are%20trying%20to%20transition%20our%20internal%20workflows%20from%20MS%20Excel%20sheets%20to%20Teams%20%2B%20SharePoint.%20One%20of%20the%20biggest%20challenges%20so%20far%20has%20been%20a%20master%20calendar%20that%20shows%20who%20is%20available%20when%20for%20capacity%20planning%20%2F%20work%20scheduling%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EDistributed%20team%20of%20about%206%20people%20(multiple%20time%20zones)%3C%2FLI%3E%3CLI%3EProjects%20are%20~6%20weeks%20long%2C%20require%202%20people%20from%20my%20team%20as%20well%20as%201-3%20others%20from%20within%20the%20organization%2C%20but%20not%20my%20team%3C%2FLI%3E%3CLI%3EVacation%20%2F%20leave%20is%20generally%20permissive%20-%20does%20not%20require%20extensive%20pre-approval%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20need%20a%20consolidated%20view%20of%20commitments%2C%20availability%20etc.%20for%20at%20least%20the%20next%20quarter%20to%20support%20staffing%20%2F%20job%20planning%20etc.%20Is%20there%20a%20configuration%20of%20a%20SharePoint%20calendar%20that%20could%20provide%20a%20coarse-grained%20GANTT%20view%20or%20something%20similar%3F%20Perhaps%20the%20new%20JSON%20capabilities%20in%20modern%20lists%20could%20be%20used%3F%20I%20don't%20want%20to%20re-invent%20the%20wheel%20if%20something%20like%20this%20is%20already%20available.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-708152%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Matt_Markahm
Senior Member

I work with a small team of consultants who are trying to transition our internal workflows from MS Excel sheets to Teams + SharePoint. One of the biggest challenges so far has been a master calendar that shows who is available when for capacity planning / work scheduling etc.

 

  • Distributed team of about 6 people (multiple time zones)
  • Projects are ~6 weeks long, require 2 people from my team as well as 1-3 others from within the organization, but not my team
  • Vacation / leave is generally permissive - does not require extensive pre-approval

 

We need a consolidated view of commitments, availability etc. for at least the next quarter to support staffing / job planning etc. Is there a configuration of a SharePoint calendar that could provide a coarse-grained GANTT view or something similar? Perhaps the new JSON capabilities in modern lists could be used? I don't want to re-invent the wheel if something like this is already available.

Related Conversations
SharePoint list calendar view with different colors
mvasconcelos in SharePoint on
2 Replies
Cannot remove a meeting from a resource room
Jim Ryan in Office 365 Calendar on
3 Replies
Outlook calendar vs Gmail Calendar
ConnectedGeek in SharePoint on
0 Replies
Staff Availability
David435 in Microsoft Bookings on
0 Replies