How to compare a date range using a cross sheet reference
Options
Best Answer
-
Try this...
=INDEX(COLLECT({Sprint}, {SSDate}, @cell <= Start@row, {SEDate}, @cell >= Start@row), 1)
Answers
-
Try this...
=INDEX(COLLECT({Sprint}, {SSDate}, @cell <= Start@row, {SEDate}, @cell >= Start@row), 1)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!