Nov 08, 2023 07:29 PM
Hi guys!
Losing my mind trying to figure this out – I thought it would be a super simple formula but just cannot get it to work. Here's the lowdown:
I'm mapping out placements for an editorial website – there's a carousel that will feature 5 articles each week, rotating between 12 different articles. I want to be able to count how many times an article has already been used in the plan.
So, I've got a table here that's grouped by each week (ie. "1. 9 Nov"). Below is an example screenshot showing the first 3 weeks (but there are 7 in total):
A breakdown of each column:
Does anyone know what kind of field or formula I could use to make this work? I've tried counts, lookups, rollups and all sorts of formulas but having zero luck.
Thanks so much!
Cheers,
Lara
Solved! Go to Solution.
Nov 08, 2023 07:57 PM
Sorry, I think I understand what you're trying to do now.
What might work is to make the "Count" field from the Article table. Counting how links from that side. Then use the lookup to display that count field.
Let me know if that works 🙂
Nov 08, 2023 07:52 PM
Thanks @Sistema_Aotearo but I've tried that and unfortunately it doesn't work!
Nov 08, 2023 07:57 PM
Sorry, I think I understand what you're trying to do now.
What might work is to make the "Count" field from the Article table. Counting how links from that side. Then use the lookup to display that count field.
Let me know if that works 🙂
Nov 08, 2023 07:59 PM
Omg! You're a genius! That worked. Thank you SO MUCH!
Sep 09, 2024 04:59 PM
I have exact same issue. However, in my case, the 'Article' link can have multiple values and the lookups can be repetitive. For example, row no. 1 can have 'Recreation' and 'Paloma' as 2 linked fields; then both these fields will have their lookups and I want count of unique values from that lookup. I tried looking/rolling up Record IDs but it didn't help. Let me know if anyone can help here. Thanks.