- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 11, 2024 12:02 PM
Hi there - I schedule shipments to be picked up on specific dates from specific sites at specific times, and I need a way to identify if I've scheduled any shipments to be picked up on the same date/site/time to make sure I'm not double booking a site. I've created a formula in my Shipments table that concatenates the three fields:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 11, 2024 12:46 PM
Kelsey,
I would normally test my answer and supply screenshots, but this one is a shot in the dark while I'm on the move. I think if you use ARRAYFLATTEN, then ARRAYUNIQUE will properly identify the duplicates.
Try something along the lines of
IF( LEN(ARRAYJOIN(ARRAYUNIQUE(ARRAYFLATTEN({DEV | Load Date, Load Site, Load Time Rollup (from Shipments)}), ", "))) < LEN(ARRAYJOIN(ARRAYFLATTEN({DEV | Load Date, Load Site, Load Time Rollup (from Shipments)}), ", ")), "Duplicates Found", "No Duplicates" )
Let me know how it goes!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 11, 2024 01:41 PM
No luck, still getting No Duplicates. ☹️ Thanks for giving it a shot. Any other ideas?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 11, 2024 05:38 PM - edited Nov 13, 2024 07:50 AM
Hmm I experimented a bit and got this to work:
IF(
LEN(ARRAYJOIN(values)) > LEN(ARRAYJOIN(ARRAYUNIQUE(values))),
"Has duplicates",
"No duplicates"
)
Link to base
Not sure how your data's set up though. If the above didn't work could you provide some screenshots of your tables so I can try to replicate it?
--
Edited, found a bug with the formula and fixed it!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 12, 2024 06:23 AM
The problem is that I'm not using any linked fields. Here's the formula on the Shipments table that concatenates the date/site/time:
And here's the setup on the Warehouses table where I've got the Rollup from Shipments and the formula field to identify duplicates:
Thank you for your help! Feels like this should be easier.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 12, 2024 06:58 AM
Hm interesting. Could you provide a screenshot of the field settings for the 'Dev' field? If you could DM me an invite link to an empty copy of your base that'd be easiest!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 05, 2025 12:41 AM
Hi, was this solved? Having the exact same issue. 🙏
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 06, 2025 02:02 PM
Hi there - this was eventually solved by putting this formula in the rollup field.
IF( LEN(ARRAYJOIN(values)) > LEN(ARRAYJOIN(ARRAYUNIQUE(values))), "Has duplicates", "No duplicates" )
And then by grouping the table by the date/site/time field so I could quickly see how many groups contained more than one item, thereby identifying the duplicates. See in the screenshot how the 01/08/25_Citi - YD_10am group has two items in it.
Hope that helps!
Kelsey
