This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question
Gert1
New Member
Since ‎11-23-2021
‎12-20-2021

My Stats

  • 32 Posts
  • 0 Solutions
  • 3 Likes given
  • 15 Likes received

philarn07's Bio

Badges Gert1 Earned

View all badges

Recent Activity

Change of Ref selection view

12-08-2021
Good day. I have a QUOTE ITEMS table with a Ref to PROD UOM giving the user the opportunity to select a PROD UOM associated with the QUOTE ITEM. When the view to select the PROD UOM is displayed I would like to show a list of PROD UOM’s Description c...

Global Constants in Formulas

12-07-2021
Good day. Maybe I am just tired, but I can’t figure this out. I have a Admin Sheet with 2 Columns. CONSTANT and VALUE To use these in a formula to for instance calculate Price of a Product, I use [COST]*(1+INDEX(ADMIN[VALUE],1)) So this “INDEX(ADMIN[...

Empty Columns Filled With Last Column with Value

12-07-2021
Good day. I have a Table with a column BARCODE. In the Excel sheet only some of the BARCODE rows have values the rest are blank, to be captured in the App. In the App all the empty BARCODE columns gets filled with the value from the previous non empt...

Excel function 'XXX' is not supported in formulas

12-05-2021
Good day. Till last night my App was executing fine with the use of Excel XLookup Function. This morning it gives the error: The spreadsheet for ‘AppName’ uses an unsupported formula : Excel function ‘_xlfn.XLOOKUP’ is not supported in formulas. I un...

Add lambda functionality

12-04-2021
Add lambda() functionality as it is currently available in Excel Insider Beta version, where the user can define his own named functions with parameters, which can be called recursively. Gert.
View more

Gert1's Ideas (1)

View more ideas