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
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 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!