Using a formula with a blank timeline column

[Pugo (David Pugo)]

Hello community! Firstly want to say how helpful this community has been, I have been learning so much so thank you all!

I am a formula noob so I apologize for how basic this question is but…

1. I want to count the days between two dates in a single timeline column and was able to use:

DAYS({Dates Working#End},{Dates Working#Start})+1

For whatever reason, it always comes up short one day which is why I added “+1” at the end. Here’s the example of the formula without the “+1”

2. Since I am collecting these timelines from a form, I have an additional timeline column that can sometimes return empty. When they are filled in, it returns the appropriate result using:

DAYS({Dates Working#End},{Dates Working#Start})+1+DAYS({Additional Dates Working#End},{Additional Dates Working#Start})+1

The issue is when the “Additional Dates Working” Column is empty (which is ~50% of the time) the formula column comes back with an error.

I think I need to use the “IF” function but not sure how and in what order.

Any help is greatly appreciated!

[GCavin (Gilles Cavin - Reinventing Formulas in monday.com)]

Hi David,

Please try:

IF(DAYS(ADD_DAYS({Additional Dates Working#End},1),{Additional Dates Working#Start}),SUM(DAYS(ADD_DAYS({Dates Working#End},1),{Dates Working#Start}),DAYS(ADD_DAYS({Additional Dates Working#End},1),{Additional Dates Working#Start})),SUM(DAYS(ADD_DAYS({Dates Working#End},1),{Dates Working#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.