Finding Distinct Values in Two Columns

Hi,


I was wondering if it was possible to find the number of distinct values in two columns. In this case I am looking to find if there is an overlap between start and completion dates for a given crew lead.

Is there a reason that I am getting 1 as my output here?

Is there any other way I can accomplish this?


Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!