How do I..

I wanted to add some smarts to a list, and I’ve ran into a problem...

I’ve got 5 calculated columns [A], [B], [C], [D] and [E] in which have returned the first character from a number of other Columns within the same List.

I wanted to get the MAX value from these 5 Columns, however, since I have already derived the value of [A]..[E] from other columns (field type “Calculated”, there appears to be a limitation on using a further Calculated Column to provide further calculations.

**Business Requirement:**

Advise worst case value from 5 different scenarios

**Example Format.**

Five List Boxes with various statements with first Character ranging from 0..5 e.g.

**List Box 1..**

0. Bright Orange

1. Blue Gray…

2. Black

**List Box 2..**

0. Ham

1. Cheese

5. Onion

**And so forth until List box 5..**

Columns [A]..[E] use a Left(xx,1) formula to derive a number value with Zero decimals.

Now I need to get the Highest Value of columns [A]..[E], in the short example above, “5” should be returned.

How can I achieve this if I cannot calculate a result from another Calculated Column?

e.g. do I replace [A]..[E] with a number column, and get a workflow to update the value? If so, how do I do this?

Any help appreciated..

Thanks

Majtx