Platform

 View Only

 How to lookup from editable table using selector

Jump to  Best Answer
  • TBMStudio
Gwyn Carwardine's profile image
Gwyn Carwardine posted 09/01/23 08:18 AM
To find values from a regular table you can use =Lookup() or ={table}:{column}[selector] (documented here: Apptio Help Frontdoor Instance Selection)
 
To find values from an editable table you can use the undocumented =Lookup_From_Editable()  
 
Lookup / Lookup_From_Editable is restricted to looking in one column.. and I want the flexibility to use a selector.
 
Is there a way to lookup from an editable table using ={editable-table}:{column}[selector] and if so - how do you specify the name of the editable table?

#TBMStudio
Jenny Franklin's profile image
Jenny Franklin  Best Answer

Unfortunately, I don't think this is supported for the 'Lookup_From_Editable' function.  Good idea for enhancement, though!


#TBMStudio