Timeline columns in formulas

Platform discussions
,
1

I have a scenario where I would like to work out the difference using a formula column between 2 timeline columns (an actual timeline and then a baseline). I was trying to make

  • 1 column display the number of working days within the baseline column
  • a column display the number of working days within the actual timeline column
  • then a column to display the difference between the two but i cant see to make it work

Any suggestions?

2

Hi @lilystevens

I think the basic issue that you are probably running into is that to use timelines in date calculations you must refer to the Start or End element in the timeline. If you use the dropdown to insert a column’s reference it will let you select the Start or End of the timeline. You can, of course, also just type it in.

For example, to calculate the number of days in a timeline use this formula:

DAYS({Timeline#End}, {Timeline#Start}) + 1

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday

1 Like
3

Hi @JCorrell thank you for the advice when i have tried this it comes up with an error in the timeline column: DAYS({Actual Timeline#End}, {Actual Timeline#Start}) + 1 any ideas on how to resolve?

4

You’re getting an error in the timeline column or in the formula column?

5

@JCorrell in the formula column

6
  1. Not that it always tells you much, but what is the message when you hover over the error icon?
  2. Do you have values in the timeline column?
7

@JCorrell It shows the below and yes there are values in the timeline columns

Screenshot 2024-11-13 at 09.11.12
Screenshot 2024-11-13 at 09.11.12287×496 10.1 KB

8

What’s your formula syntax. You must have a typo.

Want to get rid of the formula column? and write formulas that support multiple lines, variables and can update various columns at once? Take a look at the Advanced Formula Booster at https://mdboosters.com*

9

@lilystevens

Gilles comment is likely correct. Can you cut and paste your formula text here?

10

@GCavin This is the current formula:

Screenshot 2024-11-18 at 11.06.13
Screenshot 2024-11-18 at 11.06.13369×375 13.5 KB

11

Hi Lily,

Try:

WORKDAYS({Actual Timeline#End},{Actual Timeline#Start})

.i.e. with First cap on #End and #Start.

 

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.

12

@GCavin Thank you for trying to troubleshoot, but still no luck sadly. Still have the error message for ‘can not read properties of undefined (reading ‘function’)’

13

It does work on my machine, so you may want to contact support.