MAX function -most recent date

Elizabeth Aird
Elizabeth Aird ✭✭✭✭
edited 08/17/23 in Formulas and Functions

I know this should work, but it's not. I am referencing other sheets and pulling in the max date. I am getting an unparseable in return. What am I missing?

If I put just one "HOUDATE" it's invalid.

yes - I am pulling from Date column types.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!