Reference formula for returning value based on whether a date is between two dates

mpajuelo ✭✭
edited 02/07/24 in Formulas and Functions

I am using a reference sheet to reference the name of the payment period between dates. I used this equation but get #INVALID OPERATION:

=INDEX(COLLECT({Name}, {Start Date}, [Date of Shoot]@row >= @cell, {End Date}, [Date of Shoot]@row, <= @cell), 1)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!