Formula for duplicates including time

Answers
-
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
-
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
-
@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
-
@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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!