MIN and COLLECT funtion not working :-(

Options

All,

Help please. Can't figure how why my formula not working.

I'm trying find earliest start date for all actvities referencing college = 'Caldwell"

=MIN(COLLECT([Start Date]:[Start Date], College:College, "Caldwell"))

Error: #UNPARSEABLE


Thanks much

Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓
    Options

    @Caravan There is no such error called #INVALID COLUMN NAME. Is it perhaps #INVALID COLUMN VALUE? If so, this indicates that there's a column type issue with the summary column. Double check that the summary field is a Date field.

    If it is a Date column, then it might be an issue since the Start Date column is a system Date/Time column. Try wrapping your formula in the DATEONLY function:

    =DATEONLY(MIN(COLLECT([Start Date]:[Start Date], College:College, "Caldwell")))

    Regards,

    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!