Calculate a score based on multiple Enum's

[flynnd]

Hi All,

I am having difficulty figuring this one out, but am also very new to Appsheet.

I have a table that contains 6 columns of type Enum (Area 1 - Area 6)
Each Area field has the same  5 options: "None, Poor, Mild, Moderate, High"

This Table also contains a Score Column. I want to assign a number to each of the Enum options and add all 6 scores together into the scores columns, but I cant figure out how to do this.

So the end result would be a score somewhere between 0 and 24

This is what I have.

IFS(
[Area 1] = "None", [Score] = ([Score]+0),
[Area 1] = "Poor", [Score] = ([Score]+1),
[Area 1] = "Mild", [Score] = ([Score]+2),
[Area 1] = "Moderate", [Score] = ([Score]+3),
[Area 1] = "High", [Score] = ([Score]+4)
)
IFS(
[Area 2] = "None", [Score] = ([Score]+0),
[Area 2] = "Poor", [Score] = ([Score]+1),
[Area 2] = "Mild", [Score] = ([Score]+2),
[Area 2] = "Moderate", [Score] = ([Score]+3),
[Area 2] = "High", [Score] = ([Score]+4)
)
IFS(
[Area 3] = "None", [Score] = ([Score]+0),
[Area 3] = "Poor", [Score] = ([Score]+1),
[Area 3] = "Mild", [Score] = ([Score]+2),
[Area 3] = "Moderate", [Score] = ([Score]+3),
[Area 3] = "High", [Score] = ([Score]+4)
)
IFS(
[Area 4] = "None", [Score] = ([Score]+0),
[Area 4] = "Poor", [Score] = ([Score]+1),
[Area 4] = "Mild", [Score] = ([Score]+2),
[Area 4] = "Moderate", [Score] = ([Score]+3),
[Area 4] = "High", [Score] = ([Score]+4)
)
IFS(
[Area 5] = "None", [Score] = ([Score]+0),
[Area 5] = "Poor", [Score] = ([Score]+1),
[Area 5] = "Mild", [Score] = ([Score]+2),
[Area 5] = "Moderate", [Score] = ([Score]+3),
[Area 5] = "High", [Score] = ([Score]+4)
)
IFS(
[Area 6] = "None", [Score] = ([Score]+0),
[Area 6] = "Poor", [Score] = ([Score]+1),
[Area 6] = "Mild", [Score] = ([Score]+2),
[Area 6] = "Moderate", [Score] = ([Score]+3),
[Area 6] = "High", [Score] = ([Score]+4)
)

Any help greatly appreciated