Date Range


I am trying to look up a date in Sheet 1 and return a permit number from Sheet 2 if the date from sheet 1 falls with a date range on sheet 2.

Sheet 1

Sheet 2


Best Answers

  • Shahara Anderson
    Shahara Anderson ✭✭✭
    Answer ✓

    @Paul Newcome That worked beautifully! Thank you so very much. Thank you for replying so quickly.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!