Formula to pull in Quarter from a reference sheet

I have created a reference sheet called Quarter Reference Sheet that has the quarters based on a start and end date:

I have another sheet where I want to create a formula that pulls in the "Quarter" column above based on if the "Completed Date" column falls somewhere between the Start Date and End Date in the reference sheet. Example, if the Completed Date column has a date of April 1, 2020, I want the formula to look at the information in the Start Date and End Date columns in the reference sheet and pull in the value of the appropriate matching row in the Quarter column - in this example, Q1 2020.

Is this an index/match formula? If so, does anyone have a formula I could try using here that might work?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!