Hi! I need help creating a formula and not sure if it is possible.
I have a table that has several tasks with a single select option of completed, missing, or n/a. I want to get the average score of the tasks that are marked as completed.
Example: Task 1 is completed, task 2 is missing, task 3 is completed, and task 4 is completed. The average would be 75%. Or if Task 1 is completed, task 2 is missing, task 3 is missing, and task 4 is N/A. The average would be 25% and so on.