Pulling data from another sheet while evaluating a Date Column
I have a form on a dashboard that is collecting one field (client) and populating a sheet (Filter Requests) with client and Created Date. (New entries are added at the top)
I'm using a second sheet (Widget Data) to construct the data to be displayed in the dashboard widget (using data from a 3rd sheet). In order to do this I need to evaluate the Created Date on Filter Requests and pull back Client from the most recent entry.
I'm struggling to come up with the proper formula to do this.
Any suggestions would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!