I have a sheet set up with a form to track historical data for collections efforts daily. On the Summary tab I'd like it to be able to display today's stats. I'm not sure what function to use to make this happen.
How it is set up is column "A" is the date and column "B" is a percentage. I would like the summary to display if A7 is today's date, it gives the information that is in B7.
Help Article Resources
Check out the Formula Handbook template!