Try this:
1 Like
I’m pasting my response to a similar question. First, create the form and the students/users sheet, like was suggested where each task is a column and the row goes by student.
"So I had the same problem that I just solved.
I wanted to pull through a pass/fail rate from the other tab.
In the test tab:
I did a relation between the person’s name column in the main sheet and the name in the test sheet.
then a roll up count of all the all the values ( 2 passes and a fail gives a count of 3).
math column → pass/ amnt of tests = pass rate
In main tab:
rollup of the pass rate (sum)
and a rollup of the amnt of tests (count)
template column → Pass Rate Out of X Sessions where X = amnt of tests
now make a progress bar with Pass Rate as your column and the template as your title"
I’m not sure if they’re doing these activities everyday?
You might want to do their percentage completion against the number of days as well.
In which case i’d make their daily pass rate/ the overall amount of days as separate column in the student tab and make the progress bar from that.
1 Like