Display column details if row fits within date range

kburke
✭✭
Help! I'm trying to do a multi-year roadmap with costs. What I have currently is
=IF([FY YR]@row = "2024", [Est Cost]@row), which works fine. However, what I REALLY need is for the Est Cost to show up in FY24 Cost not just if the year says 2024 in it, but instead if the date in the Start date field falls w/in our fiscal year, which is 10/1/23 - 9/30/24.
I've tried several variations but am not getting it right. Help!
Answers
-
Ahh, I think I got it. Anything I'm missing?
=IF(AND([Start Date]@row >= DATE(2023, 10, 1), [Start Date]@row <= DATE(2024, 9, 30)), [Est Cost]@row)
-
Not missing anything. That's pretty much what I was going to type out.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!