Generating Calendar Dates Through a Formula and Then Moving Dates, is it possible?

Hi Team,

I’m looking to create event dates via data from another table to populate a calendar with those events. Once I have a rough schedule, I’d like to be able to drag and drop the calendar around to tweak it. I imagine colleagues would use this as well who would want a simple UI experience. Is it possible? Is there a way to drag the dates from the calendar and not loose what the formula has created as a starting point and then adjust.

All the best,


hi @Ivan_Barge ,

Did you consider to use the calendar view of a table? Bij clicking on datas in the calendar view you can add shooting days (in my example).

Cheers, Christiaan

Hi @Christiaan_Huizer ,

Thanks so much or getting back to me, I’d actually read your blog article on Coda, it was one of the gateway articles for me:)

I think it’s a neat piece of software but my colleagues won’t adopt it unless it saved time. A time saver would be my budget telling me how how many days certain events/people are going to take, I’ve made the budget, and then mapping that out in the calendar, as a starting point, based on conventions that are industry specific. Then having the ability to modify that, as we always do.
If I wanted to do a calendar without a suggested framework I could probably just do an Excel or Google Calendar, without the time saving. But I’m picking up data in the budget which I think I could use, that would be a timesaver, but I’d need to change once I had a framework to make it useful.

If that makes sense:)

All the best,

hi @Ivan_Barge

I am glad my articles helped you a bit !

if you want to amount of days related to your budget, it is (of course) possible with coda. Not every day is equally expensive (post production, production, post production) so you need to develop a logic that shows the value per work type.

Your doc is a starting points, however to benefit more from the many advantages Coda, offers you might consider a different structure, one that is more granular and less excel alike :wink:

The moment you have a budget per day for let’s say pre production and (10000 dollar and each day costs 2000), you have 5 days. If you have a starting date and all days need to follow (days 1,2,3,4,5) you can write a formula that simply shows the start & end date. If days can be split you can have day 1 and 2, a break of a few days, day 3 beak, day 4 and 5, this you can also have in Coda, but is a bit more complex, it assumes you keep track of the consumed days.

For this kind of projects, Coda is a great tool I believe, though I also feel that it might feel complex at the beginning. Step by step could mean that you create budget tables and project tables and make them talk :wink:

Hope it helps a bit, Christiaan

@Christiaan_Huizer Absolutely correct, especially since there is so much repetition in our industry… But that gets me to a place on a schedule, whereby the formulas give me dates, and they are a great, great guide or a place to start. But things will change, how do I allow for that without losing the information I’ve garnered.

I can start again or I can have a way that keeps dates intact, as a guide, that I can then move, how do I do that?

@Christiaan_Huizer I can do a switch, but then I’m kind of inputting the new quite a bit. Ideally formulas, to rough draft of schedule, then be able to drag and drop in Calendar to create final/new dates?

I am not sure if this page heads in the right direction for you, so feel free to tell me I am wrong

the issue I try to show you is that you can alter values later on the proces that in a first phase are based on formulas.

cheers, Christiaan

Hi @Christiaan_Huizer,

Apologies for my tardy response. This is how much of a newbie I am, I didn’t even see what you had done until right now:) Thank you so much, that’s very cool and will come in really handy for all the stuff I want to do!

I’ve got to redo that budget, it was my first attempt. I think I’m going to give an OBT a go as looking at that, it’s messy and there is a heap of repetition, also combine formulas so I have less columns. Which is something we do so much in our industry:) So no surprise my first effort took that approach. It is a learning curve and the more I use the software, like anything, the more I learn.

Thank you,