I am wondering how I can calculate multiple lookups to display text as output?
I want the text to say e.g. «Project type = Major/minor/etc.» based on the answers provided in these lookups.
The lookups will have the same weighting, from 1-3, and cinsists of three possible answers each.
I know it is possible to display this with Colour codes with Data Type Calculated and Result Number, but I'm not sure how to display the result as text.