Hi Macropod. Thanks for this.
In the end, I went with your suggestion and used drop-down boxes with a description of each of the selections in text below the box... and it works very well.
I am managing to calculate the values pretty easily but can't manage to translate that back to a total ranking. (Ranking column.)
i.e. If Total (bookmark) is less than 3, then display "NA". If Total is less than 7 then display "Low". If Total is less than 11 then display "High" and if Total is less than 21 then display "Critical". Alternatively, if H5 (cell reference) is less than 3... etc., as above.
I've tried a number of things, but I just don't seem to be getting the syntax right. I have tried:
{IF {REF Total}<3 NA}{IF {REF Total}<7 Low}
etc.
{IF H5<3 NA}{IF H5<7 Low}
etc. (referencing cell number)
{IF Total<3 NA} {IF Total<7 Low}
etc.
Would you please help?
I've attached the section in question.
Thanks again,
Kate.