I have made a table with all our equipment. This is linked to another planning table where I can book the equipment to different projekts.
When the equipment is booked on several projekts the start and end feilds on my equipment table(that also is linked from my planning table) will view several dates.
I’ve tried to do a calendar view based on all the start and end dates. When I do that the calendar will only show the equipment that has one start/end date. The Equipment that has more than one start/end date will not show up in the calendar.
Does anyone have a solution for this? Maybe a workaround with a formula or something?
below is a printscreen of my equipment table:
Thankful for all the help I can get!