Taking into account month AND year

Hi everyone,

I have two columns. One is the date that the form was submitted, and the other tells us which quarter we received it. Our fiscal year is from April 1 to March 31. This formula works great, but I've realized it won't account for the change in year. Currently, we are in 2020/21, but as of April 1, we will be in 2021/22. How can I adjust my formula to identify the year?

I think Ideally it could appear Q1-20/21 or any variation really. I just have no idea how to incorporate the YEAR function.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!