Hello All, would appreciate any thoughts or help with an issue regarding looking up a value from an Editable Table, using the "Lookup_From_Editable" function.
My team has built an editable table, for our end users to capture and update the value in a "status" column (Valid Values include: "Validated", ""In-Progress", "Validated"). In a separate dashboard, we have a table that looks up the value of this column from the editable table (please see formula pasted below). However, it seems as if this function does not refresh the dashboard, when an update is made to the editable table.
For example, if both the dashboard and editable table show a value of "Not Validated", but we then update the editable table to a value of "Validated", the dashboard will still show a value of "Not Validated". How can we get the dashboard to refresh and show the latest value from the editable table?
Formula:
=Lookup_From_Editable(Applications Master Data.App ID,TBM Application Status Mapping,AlfabetID, Validation Status)
If there is a better way to achieve the end result, not using this particular function, we are definitely open to hearing that as well. Thanks!
#CostingStandard(CT-Foundation)