struggling to find a simple solution to this problem…
i need to have the user input various data (i have this under control). Each input needs to return a value depending on where it sits in a corresponding list.
ie as per this screen shot, if the user inputs a listing price of $550,000 it should return 0%, or if they input client difficulty as Difficult, it should return 15%.
Can make this work based on very lengthy if then else columns but id like to keep this variable if possible as the ranges in the lookup lists may change.
If you have the table from your screenshot included as a table in your app, you can use a Query column and Single Value column to get corresponding impact values in cases where you might be dealing with ranges of values. For everything else, you can use a Relation column and Lookup column to get the impact value from matching values.
Thanks Jeff - Query column and Single Value has done the trick. Had to filter the Query to be > actual listing price. Feels like i tried all but this scenario before reaching out for support.
