Next earliest date after today


Need help with a formula for this. I have a column of end dates. It should be showing this 8/12 date but I cant get it to show up.

Best Answer


  • Chris Carroll

    Yes that was perfect! Sorry I couldnt describe it better. I do have a question. why do you have to input the range twice? That's where I was getting it messed up, I was only inputting it once. everything else, I was on the right path.

  • MCorbin
    MCorbin Overachievers Alumni

    Because the function (Collect) syntax requires it....

    When you set up the function, you first tell it the range you want it to collect (in this case, the date column). Then it wants to know your criteria for which ones you want to collect - but you have to tell it the range that your criteria applies to first, and then the actual criteria.

    A lot of times, the range your collecting and the range you're using for criteria are the same, as with this formula, but your formula doesn't know that, so you have to tell it.

    And they're not always the same, so it gives you the flexibility to collect data even when that particular data element isn't part of the criteria.

    (Hopefully that makes sense)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!