Building out a Governance AppSheet

AppSheet AppSheet Q&A
, , ,
1

I am working on building a Governance AppSheet that captures key parameters, including:

  • Introduction
  • Paraphrasing
  • Communication
  • Resolution
  • Closing

For each parameter, I am using the Enum function with three predefined options:

  • Aligned (10 points)
  • Partially Aligned (5 points)
  • Not Aligned (0 points)

I would like to calculate the Total Compliance Score (%) by assigning scores to each parameter and deriving an overall percentage score based on the total possible points.

I would like with a Formula Expression to use to Calculate the Total Compliance score (%) given my Use Case

2

What is your question?

3

Can someone help with an Formula Expression to use to Calculate the Total Compliance score given my Use Case?