Using start date/end date columns as input to timeline

Hi Monday fans,

I have imported a long list of budget breakdown (1588 pulses) with a column “Start date” and a column “End date”. I would like to use these two columns as inputs for a new timeline column. Any idea on how to do that?

Hi @maleroy , Matthieu,

I suggest to use Integromat for this. It is a bit of a learning curve, but I am confident this can be done by iterating through all the items of the board / group and then use the two dates to create a timeline out of it.

I have the same request. I’ve imported a list from Excel originally generated from MS Planner with 2 columns one for start and one for end date. As I understand, I need to convert these to timelines to be able to see it in a Gantt Chart. I won’t do it manually - 1,000+ lines across 10+ boards, and it seems silly to have to use a 3rd party to perform this basic task in a PM software. Any other way of doing this?

Hi @cgrynberg, @maleroy

I have an app with a feature that uses this configuration sentence:


It is still in development (expect to release it in a few days).

Can you let me know what column types you are using to hold the start and end-dates? Are these monday Date columns or text columns holding a date in a specific format. The feature is currently using monday Data columns but i case you use a specific format please let me know how that format looks like. I can try to incorporate other date formats in this app.

As the conversion is triggered by a status changing to a value (e.g. “Convert”) it can easily be used to change large number of rows in one go as you can multi select the items where you want the conversion to take place.

Hi @cgrynberg, @maleroy

The automation feature is now adde to the app, see Monday app with automations released
Hope it helps you migrating and converting, have fun!

Hi Bas,

I am currently testing your app. Is there a way to use a formula column as an input rather than a date column?
Use case: We calculate an actual start and end date for a task because quite often our tasks are delayed and therefore we would like to generate a new timeline based on these inputs.

Thanks

Hi @anayer

I don’t think this will be possible as the output of a formula column can never be used in any automation. The output is generated client side (within you browser) and the backend (where the automations live) is not aware of these “client side columns”.

I cannot find this automation, was it removed?

Hi Johnnie

The installation link might have changed due to the marketplace rollout. The app can be installed through the market place or with the direct installation link: https://auth.monday.com/oauth2/authorize?client_id=eb5077efff67bdb6b593d09d0b0b6889&response_type=install