Formula for duplicates including time

System

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

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

Georgie

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

Andrew Stills

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

https://community.smartsheet.com/discussion/comment/468312#Comment_468312

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 Stills

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

Georgie

@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