Index & Collect Using Date Range

Hello,

I'm trying to return cell values from another sheet based on a date range in a date field but I can't seem to get the formula to work.

In a new sheet, I want to return the value of a specific cell from a different sheet based on the date range (3 months prior to today) field. This is what I tried and it doesn't seem to work. I'm also open to any other suggestions.

I tried (today)-90 but that didn't return any values

=INDEX(COLLECT({OSS Test Range 3}, {OSS Test Range 2}, <DATE(2022, 4, 1)), 1)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!