#INVALID COLUMN VALUE when using =MAX for a date value in cross sheet formula

Good afternoon!

I am attempting to use a cross sheet forumla to see the most recent date populated in a column from a different sheet. The forumla I am using is :

=MAX({EMEA Customer Health Score Range 12})

I get the error: #INVALID COLUMN VALUE

If I use formula '=MAX([Data Request Date]1:[Data Request Date]139)' in the original sheet I wish to pull the data from I get desired result.

Please help!

Kirsty

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!