The idea being - how to track personal OKRs and see the progress.

I’ve created a version of the base concept but am having trouble with two things:

- Column “Progress (KR%)” doesn’t seem to be calculating correctly the percentage - it does 1% rather than 100%. I imagine there is some basic math I just skipped over but am curious what this is…

- The formula I’m using is: {Progress (KR)}/{Key Result}

- What formula to use to calculate column “Progress (O%)”. In plain terms it would be "If column called ‘Objective’ is ‘Objective 1’, then add the numbers in column ‘Key Result’ and divide by ‘Progress (KR)’. And then the same for objective 2 and objective 3.

Help would be greatly appreciated and I’d be happy to push this out to the community as a resource if others would find it helpful (I haven’t come across this yet but if it’s already out there, I’d be super happy to just use that one instead).

Thanks so much!