Max Value of a column by Today's Date

Bob Parrett

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,

Bob

Mark Cronk

Hi Bob, Try:

=MAX(COLLECT([Temperature]:[Temperature], [date]:[date], today()))

Work?

Mark

Mark Cronk

Hi Bob, Try:

=MAX(COLLECT([Temperature]:[Temperature], [date]:[date], today()))

Work?

Mark

Bob Parrett

That worked. Thank you very much. I guess I was making it more complicated than needed.

Mark Cronk

No worries. I've spent decades making formulas more complicated than they need to be. Glad it worked for you. Mark