Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Overlaps in Start and Finish dates

✭✭✭
edited 09/26/22 in Formulas and Functions

Hi

Can someone suggest me a formula that alerts me whenever there are any overlapping Start or Finish dates across ALL the entries that I will receive in my Leaves Management app?

For example, all the leave applications submitted by the user abc@xyz.com must not have any overlapping Start and Finish dates; and if there are any date overlaps, then a formula must alert me about it!

Thanks

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions