Formula for calculating overlapping dates for approval tasks
I am trying to find a way to properly calculate how long an approval takes from an outside source. Is there a formula or a workflow that can take overlapping dates and give the correct answer? I also need the formula to be able to update if the initial start date gets pushed out.
I have attached an image of the date layout. If the dates overlap (for example 1/11/24  2/21/24 and 1/12/241/12/24 have a day overlap so the total would be 30 days not 31). I can clarify if needed.
Answers

Are you using the dependency settings in the sheet?

@Paul Newcome yes, I believe so.

Have you tried setting up predecessors?
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 183 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!