I’m not sure if this is a bug, or just a limitation of Row Owners.
I’m trying to calculate the number of submissions for all users so I can display a running total to all users. The Submissions sheet uses Row Owners to protect the actual submissions.
My assumption was that a rollup would still function with Row Owners because I’m just trying to get a count of rows, but it turns out it doesn’t (it just rolls up the row owner’s rows). I’ve been racking my brain trying to figure it out and it was only after disabling row owners that I was able to get to the bottom of it.
I can create a work-around, but I’m just curious if this is something that could be changed/updated so that calcs aren’t dependent (or maybe have the option of being independent) of Row Owners settings.