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
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 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!