Formula for duplicates including time

This discussion was created from comments split from: Formula for Duplicate Entries.

Answers

  • Andrew Stills
    Andrew Stills ✭✭✭✭✭

    I believe I have this formula set up correctly. However, my sheet is often updated multiple times within a day. It doesn't seem to work with the time value in the created date field. Is there a way to add the time?

    I'm sure I could manage this with a Julian date/time but that would require an additional column. Any suggestions on a more elegant way?

    Thanks

    Andrew

    He who fails to plan is planning to fail. - Winston Churchill

  • Georgie
    Georgie Employee

    Hi @Andrew Stills,

    I’ve reviewed the Formula for Duplicate Entries thread you commented on, but I’m not sure exactly which formula you’re using. 

    I tested on my end with a formula that checks for duplicates in the Created date system column and confirmed that the formula below checks rows that were created at the same timestamp, but not rows that are created on the same day at different times:

    • =IF(COUNTIFS(Created:Created, Created@row) > 1, 1)

    However, I’m not sure that’s what you’re looking to achieve. If it’s not, could you let us know the formula you’re using and provide a screenshot of your sheet so that we can fully understand what you’re trying to do? 

    Thanks,

    Georgie

    Need more information? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

  • Andrew Stills
    Andrew Stills ✭✭✭✭✭
    edited 01/21/25

    @Georgie, After posting this I found a way to digest the date & time from the created column. I posted it to this thread here:

    And, yes, I was using COUNTIFS as you indicated above. Must have forgot to paste that in the request,

    Apologies I didn't think to post my solution with my original request. Also, although mine accomplishes my task, I would defer to @Paul Newcome's solution provided after my post as a more elegant solution. Please see his reply to me on page 19 for a great solution.

    Cheers

    Andrew

    He who fails to plan is planning to fail. - Winston Churchill

  • Andrew Stills
    Andrew Stills ✭✭✭✭✭
    edited 01/21/25

    @Georgie please see my reply above… it wouldn't let me click your user in the list even though it appeared.

    Andrew

    He who fails to plan is planning to fail. - Winston Churchill

  • Georgie
    Georgie Employee

    @Andrew Stills,

    Ah, thank you - I see your reply and conversation with @Paul Newcome on the related thread now. Glad you got this resolved!

    Georgie

    Need more information? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!