We request the ability to use columns retrieved via a Lookup Column (specifically Number, Currency, or other Calculation types) as variables within the formula of a Calculation Column in the same iSheet.
Current Limitation: Currently, the Formula builder does not list Lookup columns as available variables. As confirmed by HighQ Support and the documentation: "Number and calculation columns included via a lookup column may not be used for calculation columns."
Impact:
-
Data Integrity: Eliminates the need for manual data duplication or complex Workflow rules just to copy values into "native" number columns.
-
Efficiency: Allows for true relational data modeling across different iSheets without workarounds.
Thank you for considering this enhancement.
