Display column details if row fits within date range

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!