Display Value from Today

Each day we enter the number of new employees by type. In that sheet, I'd like to display the value from today. I have a date column called Day and a column called Intern. I want the summary filed to display the number as it changed each day. I've tried various forms of Vlookup, Index and Max with no luck.

Thanks for your help!!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!