Max Children with Dates or Text


Hi All

I am trying to pull either a max date or text into a parent row and I am getting an #invalid data type error. The column is a date column. If I change it to a text column, I receive #invalid column value.

I'm not sure this is the correct formula. I am using =OR("TBD", MAX(CHILDREN()). Any ideas?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!