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
-
@Kaykay Double check that the column you are referencing with {OSS Test Range 2} is really formatted as a date column. If it is actually a text/number column filled with date values, you cannot perform date calculations or comparisons against it.
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!
