Forum Discussion
Formula Help
I manage buildings with 168 rooms. the occupants of these rooms from time to time are selected to be part of a weekly cleanup crew that are randomly selected. The formula below provides filters for ...
As in my reply to your PM:
Since you want to select only persons who checked in 6 months or more before the current date, you should use
(Room_Roster[Room Assign/Check-in Date]<=EDATE(TODAY(), -Lists!L5)
Similarly, you want to select only persons who completed duty 12 months or more before the current date, so
(Room_Roster[Date BO Duty Completed]<=EDATE(TODAY(), -Lists!L7)
You already select only persons where Selected Date is empty, so you don't have to add an extra condition for Selected Date is not empty and Completed Date is empty.