Max Value of a column by Today's Date

New to Smartsheet and Functions, so help would be greatly appreciated.

I am trying to create a sheet summary function that collects the max temperature of the data from a column for todays date. New data added each day. Here is what I have tried:

=INDEX(COLLECT(Temperature:Temperature, Date:Date, MAX(Date:Date), Temperature:Temperature, MAX(Temperature:Temperature)), 1)

which returns #INVALID VALUE

I also alternatively tried:

=INDEX(COLLECT(Temperature:Temperature, Temperature:Temperature,MAX(Temperature:Temperature, Date:Date, TODAY())), 1)

which returns #INVALID DATA TYPE

Help please!

Thank you,


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!