AnsweredAssumed Answered

Lookup on multiple oolumns

Question asked by gerrit.vaneijk@gallagher.com on Nov 17, 2016
Latest reply on Dec 8, 2016 by andrewg@intellinet.com

Hi

 

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?

 

Thanks

Outcomes