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,

Bob

Find more posts tagged with

Accepted answers

Mark Cronk

Hi Bob, Try:

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

Work?

Mark

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.