List View

%3CLINGO-SUB%20id%3D%22lingo-sub-1883048%22%20slang%3D%22en-US%22%3EList%20View%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1883048%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%202%20lists%20that%20I%20use%20to%20create%20an%20Absence%20Planner%20for%20our%20workplace.%201%20list%20has%20the%20absence%20types%2C%20start%20and%20end%20dates.%20The%20second%20list%20has%20the%20members%20names%20and%20work%20area%20the%20belong%20to.%20This%20works%20very%20well.%3C%2FP%3E%3CP%3EWhat%20I%20a%20trying%20to%20do%20is%20create%20a%20separate%20list%20view%20to%20show%20what%20members%20have%20not%20made%20an%20entry%20for%20%5BToday%5D%20and%20the%20previous%2020%20days%20(rolling)%20not%20including%20week%20ends.%3C%2FP%3E%3CP%3Eeg.%26nbsp%3B%20in%20the%20below%20example%20for%20the%2013th%20Nov%202020%20both%20Fred%20and%20Mary%20would%20appear%20on%20the%20list%20as%20they%20do%20not%20have%20an%20entry%20that%20covers%2013th%20Nov%202020%20and%20Tom%20would%20not%20show%20on%20the%20list%20because%20he%20has%20an%20entry%20that%20covers%20the%2013th%20Nov%202020.%20I%20would%20like%20the%20list%20to%20group%20by%20work%20area.%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%22100%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2213.227146814404431%25%22%20height%3D%2228px%22%3EMember%3C%2FTD%3E%3CTD%20width%3D%2221.398891966759003%25%22%20height%3D%2228px%22%3EAbsence%20Type%3C%2FTD%3E%3CTD%20width%3D%2222.610803324099724%25%22%3EWork%20Area%3C%2FTD%3E%3CTD%20width%3D%2217.763157894736842%25%22%20height%3D%2228px%22%3EStart%20Date%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%20height%3D%2228px%22%3EEnd%20Date%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2213.227146814404431%25%22%20height%3D%2228px%22%3EFred%3C%2FTD%3E%3CTD%20width%3D%2221.398891966759003%25%22%20height%3D%2228px%22%3EAnnual%3C%2FTD%3E%3CTD%20width%3D%2222.610803324099724%25%22%3EOffice%3C%2FTD%3E%3CTD%20width%3D%2217.763157894736842%25%22%20height%3D%2228px%22%3E02%20Nov%202020%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%20height%3D%2228px%22%3E12%20Nov%202020%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2213.227146814404431%25%22%3EFred%3C%2FTD%3E%3CTD%20width%3D%2221.398891966759003%25%22%3EPersonal%3C%2FTD%3E%3CTD%20width%3D%2222.610803324099724%25%22%3EOffice%3C%2FTD%3E%3CTD%20width%3D%2217.763157894736842%25%22%3E16%20Nov%202020%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%3E30%20Nov%202020%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2213.227146814404431%25%22%3EMary%3C%2FTD%3E%3CTD%20width%3D%2221.398891966759003%25%22%3EPersonal%3C%2FTD%3E%3CTD%20width%3D%2222.610803324099724%25%22%3EWorkshop%3C%2FTD%3E%3CTD%20width%3D%2217.763157894736842%25%22%3E05%20Nov%202020%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%3E12%20Nov%202020%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2213.227146814404431%25%22%3EMary%3C%2FTD%3E%3CTD%20width%3D%2221.398891966759003%25%22%3EAnnual%3C%2FTD%3E%3CTD%20width%3D%2222.610803324099724%25%22%3EWorkshop%3C%2FTD%3E%3CTD%20width%3D%2217.763157894736842%25%22%3E16%20Nov%202020%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%3E19%20Nov%202020%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2213.227146814404431%25%22%20height%3D%2228px%22%3ETom%3C%2FTD%3E%3CTD%20width%3D%2221.398891966759003%25%22%20height%3D%2228px%22%3EAnnual%3C%2FTD%3E%3CTD%20width%3D%2222.610803324099724%25%22%3EWorkshop%3C%2FTD%3E%3CTD%20width%3D%2217.763157894736842%25%22%20height%3D%2228px%22%3E02%20Nov%202020%3C%2FTD%3E%3CTD%20width%3D%2225%25%22%20height%3D%2228px%22%3E20%20Nov%202020%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1883048%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2010%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have 2 lists that I use to create an Absence Planner for our workplace. 1 list has the absence types, start and end dates. The second list has the members names and work area the belong to. This works very well.

What I a trying to do is create a separate list view to show what members have not made an entry for [Today] and the previous 20 days (rolling) not including week ends.

eg.  in the below example for the 13th Nov 2020 both Fred and Mary would appear on the list as they do not have an entry that covers 13th Nov 2020 and Tom would not show on the list because he has an entry that covers the 13th Nov 2020. I would like the list to group by work area.

MemberAbsence TypeWork AreaStart DateEnd Date
FredAnnualOffice02 Nov 202012 Nov 2020
FredPersonalOffice16 Nov 202030 Nov 2020
MaryPersonalWorkshop05 Nov 202012 Nov 2020
MaryAnnualWorkshop16 Nov 202019 Nov 2020
TomAnnualWorkshop02 Nov 202020 Nov 2020

 

Thanks

0 Replies