Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 11, 2022 09:41 AM
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…
Sep 11, 2022 10:18 AM
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.
Sep 11, 2022 05:03 PM
Thanks for the tip @ScottWorld!
Would you (or anyone) know if there’s ANY project management software that solves the problem I described above?
Sep 12, 2022 12:03 AM
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
Sep 16, 2022 09:48 AM
Hey @Adam_TheTimeSavingCo - I’d love to give this a test!!
Possible to share the code & any table setup instructions required?
Sep 16, 2022 07:33 PM
Yeap sure! Lemme DM you