i’m looking for a solution to a certain problem. I have a sheet named “Task numbers” which have particular task numbers and periods of time (start and finish) for when they are active.
I need to automatically assign the task number from the first sheet based on task date i select in this one. I can’t find the approach on how to solve this, i’d gladly appreciate any help.
On the sheet in the second image, your “number selected” field should link the the “unique task field” on the sheet created in step 1.
Apply dynamic filtering in the link and load relationship created in step 2; your “Task Start” field should be later (greater) than the UTN start field, and your “Task Start” field should also be earlier (less) than the UTN end field.
Once the above design steps are completed, when creating a task entry, you will be able to select the “unique task number” based on the date entered in the “Task start” field using the dynamic filtering criteria.