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:
- Name: The name of the week (so it can be referenced in "List of placements")
- Article: This links to another table with a long list of hundreds of articles
- Placement: A single select field with the name of the particular spot the article will take in the carousel
- Week: Single select field with the name of the week (used to group the articles as I couldn't do single select as the first column)
- List of placements: A lookup field that pulls all the weeks that article was featured (so the lookup source is "Article" and then it's pulling in the "Name" listings)
- Count: The field that's not working! I simply want this to count the number of records in the "List of placements" lookup field. So that first row should say 3, the second row should say 2, and the third row should say 1. But I can't get it to do anything other than 1 or 0.
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
1 Solution
Accepted Solutions
