I have a list with three columns: "Impact","Likelihood","Risk". I also have a form where the users select the impact and likelihood and the form should then calculate the risk (based on this list).
I am trying to use the form runtime function lookup() , but this can only filter on 1 column, so I was thinking of nesting this somehow. I can not find how to do that, though, as the input only allows a single value. Would anybody know how to do this?