Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 07, 2018 12:57 PM
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:
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!
Dec 07, 2018 01:11 PM
As far as #1 goes, just add *100
to the formula – Airtable’s “Percentage” fields don’t convert to actual percentages, they just stick a “%” onto the end of the result of the formula or input.
({Progress (KR)} / {Key Result}) * 100
I don’t understand how your request #2 is any different than #1 – it looks to me like you are just requesting to do the same equation that #1 is expressing. You say
but your Key Result
column is a single number input field. There is no way for it to have more than one number. Do you mean that you want to SUM all of the Key Results that are linked to “Objective 1” together, and figure out their collective Progress (KR)
? If so, that would need to be done in the “OKR’s” table where “Objective 1” exists. You’d use a Rollup field pointed at the “End of Year Plans” table and the “Key Results” field, and using SUM(values)
, and then the same for the “Progress (KR)” field, with SUM(values)
. Then, create a new Progress (KR%
field in the OKR’s table that calculates the percentage for an entire Objective.
Dec 07, 2018 01:53 PM
Wow thank you so much! I was not expecting such a thorough assist here. That totally worked. Oddly, after maybe even years of using Airtable, I actually think this helped me understand how to use various field types and when tables can connect meaningfully during calculations.