Averege

AppSheet AppSheet Q&A
1

Hello everyone, everything good?

I’m trying to put together a formula but I’m not having success.

I have a spreadsheet which has two tabs (OKR and Activities)

They are talking to each other.

My application works as follows:

the user registers the OKR;
After that, he can register the activities and add the percentage.

What I need help with is so that when he finishes the activities, the average of the activities appears in OKR.

Example:

OKR to be healthier:

Activities: Train more,80%
Eat more healthily,20%

In OKR (already completed) 50% should appear.

How to make this formula?

Hugs

2

Hey, i am having trouble to underestand. Maybe you can explain a little more :slightly_smiling_face:

I guess that solution will be asociated with using app formula with “if” or to show o not “Show if” option.. but give me more info please

3

Hello Nicolas!
Thanks in advance for your help!

In the OKRS Menu I have the team’s goals, as shown in the print below:

Yan1_0-1705435578710.png
Yan1_0-1705435578710.png1154×540 39.4 KB

When I click on “Migrate CloudM” (for example) I can add the Key Results:

Yan1_1-1705435678472.png
Yan1_1-1705435678472.png992×553 42.1 KB

Note that I have the percentage (already done)

Yan1_2-1705435714584.png
Yan1_2-1705435714584.png705×667 16.3 KB

What I need is for the app to calculate the percentages of the key results and show the average. Example:
I have 3 key results with the percentage, 20%, 80% and 100%. I need the OKR to show 66.66%

4

Ok!
One more question.
How do you conect the 2 tables?
The main one (OKR) and the other with the Activities.
Is one “child table to the other”?
Show some pics of the data section of your app

5

Nicolar,

follow the prints:

OKRS

Yan1_0-1705436842028.png
Yan1_0-1705436842028.png950×597 25 KB

Atividades

Yan1_1-1705436880926.png
Yan1_1-1705436880926.png872×571 26.3 KB

6

If you have 2 tables conected with the Project ID, I think that the OKR will be an App Fomula similar to this:
sum(select(ActivityTable[Achieved%],[Project ID]=[_thisrow].[Project ID]))
/
count(select(ActivityTable[Activity id],[Project ID]=[_thisrow].[Project ID]))

Its like saying, Appsheet: sum please all the % achieved of the activities that have this same project of my OKR. Then for calculating the % , divide for the quantity of activities we have on this proj.

7

Check if with my answer below you can resolve. I think it will guide you :slightly_smiling_face:

8

Nicolas,

I’m just having difficulty swapping fields for spreadsheet columns.

I’ll try it here and let you know if I succeed.

Hugs

9

Try this one:
sum(select(Atividades[Já realizado],[OKR]=[_thisrow].[ID]))
/
count(select(Atividades[Já realizado],[OKR]=[_thisrow].[ID]))