Counting auto-number generated dates

Options

I've been trying to figure out and find how I can count a certain date for tracking purposes. We need a daily report of the data we input everyday and I need to track how many times data has been gathered for each day.

And can the auto generated dates format be edited? For example, I don't need the time stamp, just the date for columns that are auto-numbered.

Best Answers

Answers

  • Ma Beatriz Dizon
    Ma Beatriz Dizon Employee
    edited 12/07/20
    Options

    Hi @Mark Cronk , thanks for replying. I tried the DATEONLY function but once I press enter it says INVALID COLUMN VALUE.

    I'm not quite sure what I did wrong. Maybe I'm missing something, I just can't put my finger on it.

  • Ma Beatriz Dizon
    Options

    Thanks @Mark Cronk ! That definitely worked!

  • ika
    Options

    I entered this exact function =COUNTIF([Picked]:[Picked], =today()).

    Picked is an auto-generated date field.

    There are 17 rows with today's date.

    This formula returns an answer of 26.

    There are no blank rows.

    Why is this calculation wrong?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!