#INVALID COLUMN VALUE Error with Max() Function

Michael Lukson

Hi All,

I'm was trying to use the Max() function to grab the latest date in a supporting sheet. From reading it looks like this is a valid use of the function. The sheet being referenced is set as a date field in properties.

I'm basically building a small sheet to feed the latest daily balances on some company bank accounts for the Finance team to use. Originally I tried building a report with the filter feature set to "In the Last (days)." However that didn't work too well on Mondays since the last entry would be a Friday (weekend no posting). So my second idea was to build a sheet that would pull the values I needed using the Max function to grab the latest date entry. However, as you can see below I'm getting an error message. Any ideas why I'm getting this error message or an alternative solution?

Figure 1 - Reference Sheet

Figure 2 - Error Message

Mark Cronk

Hi @Michael Lukson ,

=MAX(date:date) or MAX({insert range name}) if using am external reference will return the most recent date. Your date and primary columns need to be set to a date property.

If you need to add a criteria you'd use a MAX(COLLECT({date range}, criteria range, criteria)) formula.

Help?

Mark

Mark Cronk

Hi @Michael Lukson ,

=MAX(date:date) or MAX({insert range name}) if using am external reference will return the most recent date. Your date and primary columns need to be set to a date property.

If you need to add a criteria you'd use a MAX(COLLECT({date range}, criteria range, criteria)) formula.

Help?

Mark