Record specific data and transfer to separate sheet?

[loumulet]

I need to count and record how many 100’s a specific user has in the “completion column” in the habit tracker sheet and have that recorded in the “# of 100s” column in the users sheet.

[loumulet]

this is the users sheet for reference.

[Jeff_Hager]

Create a Template column that joins the user email and completion column. In the user table create a template column that joins the user email and the number 100. Then create a relation that links both template columns together. Finally create a Rollup column that counts the number of items in the relation.