The Community will be undergoing maintenance from Friday February 21 - Friday, February 29 and will be "read only" during this time. To learn more, check out our Announcements blog post.
Hey all,
I have a Lookup field that is returning a list of numbers, but for some reason the list is not in numerical order. Is there any way to to return “7, 27, 28, 90, 123, 123” instead of “27, 7, 28, 90, 123, 123”? Alternatively, is there a way to...
Hey there,
Is there some way to count the number of entries in a Lookup field in the same table?
I have a Lookup field called ‘Roles’—it references another field on the same sheet called ‘Movies’ and spits out a list of acting credits associated with...
Hey @Loic_Sanchez,
Sadly COUNTALL({Roles}) just lists the number 1 in every single cell instead of how many individual roles there are in the Roles lookup column.
I’d love to include a link to the specific table I’m talking about, or even include a screengrab, but for some asinine reason I’m not allowed to.
I want to simply count the number of entries in a Lookup field that which collects all the roles belongi...
@Mac Forgive me if I’m misunderstanding, but I don’t want to reference fields on another table—I just want to count the number of entries in a Lookup field on the same sheet.