Compare dates in two different sheets and return a value

I have a reporting use case where the project managers have to enter a reporting code so that reporting roll up occurs in the correct fiscal quarter. I want to automate the assignment of the reporting code so project managers do not have enter the code . I created a sheet that contains a reporting code for fiscal years and quarters, and then want to test the projected start date against the reporting code start date. So essentially,

if {reporting code start date} greater than or equal to [Projected Start Date]@ row, return the corresponding reporting code.

Same for

if {reporting code end date} less than or equal to [Projected End Date]@ row, return the corresponding reporting code.

Screen shot of the fiscal year/quarter table is below:

Any help is truly appreciated.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!