I have a "Task" Table with a Timeline View to track my employees’ resource utilization. So far I love the tool! BUT... I am running into a major limitation when I try to enter multiple “Days Off”. To my knowledge, the “Days Off” Date field can contain only one Date. Is that true?
Multiple days off must be entered individually in my “People” table, then linked to a Lookup Field in my “Tasks Table” which populates a date field with all days off as comma separated dates.
The problem with this approach is that most employees take multiple, consecutive days off, not individual days. I don't want to have them enter each day one-at-a-time for a 5 day vacation. Ideally I would use a form with a date range (Vacation Start—Vacation End) and let the system do the calculation for the Utilization.
Am I making sense? If so, does anyone know if there is a solution to this issue?
the view timeline with the utilization bar
Thank you,