Link in assignment with a lookup that is between two dates
We have scheduled out assignments of who has priority for some planes our company uses. This is assigned at the beginning of each week (Monday to Sunday). I want to link in the assignments from our scheduling smartsheet into our tracking sheet that we use for when a plane is in use. This will be used for our tracking in 2021, so I have put in a stock date of 01/05/21 for now.
So, based on the name of the plane, I want to bring in who has the assignment into our "assigned to" column on our tracking sheet. Hopefully some screenshots help. The circled area is where I want the assignment to go into.
Thank you for your time
Help Article Resources
Check out the Formula Handbook template!