Function Help

haley.harris ✭✭
edited 12/09/19 in Formulas and Functions


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.

Thank you,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!