Skip to main content

Project Management | Calendar View Issue

  • September 11, 2022
  • 5 replies
  • 43 views

I’d like to use Airtable for project management. External stakeholders often ask for a Calendar View to see planned work. We do not work on Saturdays or Sundays, so I make sure weekend dates are registered as “Holidays” in the Gantt Chart settings.

My problem: Is there any way to automatically prevent tasks from appearing to occur over weekends in Calendar View? I send out calendars and people automatically assume I am expecting them to work over weekends.

What It Looks Like Now…

What I WANT IT To Look Like…

5 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9808 replies
  • September 11, 2022

Welcome to the community, @Scott_McClennen!

It doesn’t actually solve your problem, but if you click on those little tiny arrows next to the weekend names, the weekends will get extremely small.


  • Author
  • New Participant
  • 2 replies
  • September 12, 2022

Welcome to the community, @Scott_McClennen!

It doesn’t actually solve your problem, but if you click on those little tiny arrows next to the weekend names, the weekends will get extremely small.


Thanks for the tip @ScottWorld!

Would you (or anyone) know if there’s ANY project management software that solves the problem I described above?


TheTimeSavingCo
Forum|alt.badge.img+31
  • Brainy
  • 6460 replies
  • September 12, 2022

Thanks for the tip @ScottWorld!

Would you (or anyone) know if there’s ANY project management software that solves the problem I described above?


Hi @Scott_McClennen, heh when I had this problem I ended up throwing some code together that would split my tasks out into weekday only so that the calendar wasn’t disrupted

And so I have a Tasks table and a Calendar table, and clicking the button will create the appropriate records in the Calendar table

Here’s a gif of it working:

It might be pretty overengineered for your use case though, and I can’t guarantee it works perfectly as I just threw it together for myself. I’ve got no complaints though!

Lemme know if you’d like the code and I’ll send it over


  • Author
  • New Participant
  • 2 replies
  • September 16, 2022

Hi @Scott_McClennen, heh when I had this problem I ended up throwing some code together that would split my tasks out into weekday only so that the calendar wasn’t disrupted

And so I have a Tasks table and a Calendar table, and clicking the button will create the appropriate records in the Calendar table

Here’s a gif of it working:

It might be pretty overengineered for your use case though, and I can’t guarantee it works perfectly as I just threw it together for myself. I’ve got no complaints though!

Lemme know if you’d like the code and I’ll send it over


Hey @Adam_TheTimeSavingCo - I’d love to give this a test!!

Possible to share the code & any table setup instructions required?


TheTimeSavingCo
Forum|alt.badge.img+31
  • Brainy
  • 6460 replies
  • September 17, 2022

Hey @Adam_TheTimeSavingCo - I’d love to give this a test!!

Possible to share the code & any table setup instructions required?


Yeap sure! Lemme DM you