Hi guys,
My first post here so I shall try my best to adhere to the rules and explain my problem as best i can.
I am putting together a report that automatically populates a dashboard depending on data entered. In this instance, I have a list of people, their personal details and a column for the date they exited the temporary accommodation. I am wanting to populate some cells on the dashboard for people that have exited in the last month.
Data
Name DOB House Exit Date Bob Brown ##/##/## XYZ - Ryan Red ##/##/## XYZ - Gary Green ##/##/## XYZ 1/11/19 Brad Blue ##/##/## XYZ - Peter Purple ##/##/## XYZ 3/11/19
If i enter an exit date into the data table i would like it to return the Name and Exit Date but, only if there is data in the Exit Date column. Thus far i have been able to populate the dashboard if all people have an exit date but am left with some blank rows if there is only one or two who have departed.
I hope this makes sense and apologies if i have failed to include anything.
Any help would be much appreciated.
Bookmarks