We have been waiting for user-specific rollups for a long time but there’s no ETA on that.
The only way, for now, with a single user-specific column, is to convert the user-specific column into another sheet, with each value for each user stored into its own row. Then you use a relation + rollup to get back the value you want, but it would consume a lot of rows.
Another way to do it is to have 2 columns, let’s say for ratings of an article.
- Global total likes for the post
- Global total ratings for the post
- Signed-in user’s like for the post (user-specific)
Users will submit a rating through a compound action, let’s say I want to rate 5 for the post:
- Add 5 to global likes
- Add 1 to global total ratings
- Add 5 to signed-in user’s like
Average rating = Global likes/Global total ratings