MIN and COLLECT formula not working

Options

Hi all,

I am trying to return the oldest date from a date column where a checkbox is checked in another. The formula I currently have is below

=MIN(COLLECT({Change Requests Range 3}, {Change Requests Range 5}, 1))

The error I get returned is "#INVALID COLUMN VALUE".

I have screenshots below of the range details as they are referencing another sheet.

Can anyone assist with this?

Thanks,

John

Tags:

Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @John_Foster

    It looks like your OriginalDate column could be a date type column. If so, the column with the formula needs to also be in a date type column as you are trying to return a date.

    Hope that helps.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!