cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Support formula in Importable Spreadsheets

Support formula in Importable Spreadsheets

For example

1) Use importable spreadsheet to rename PARTS to have same name as an existing ATTRIBUTE.

Export an importable spreadsheet  and use a formula to make the value for NAME equal the value for the attribute LONG (in the cell for name enter =B7 [the cell reference for LONG]). Save the file and import the spreadsheet, but the NAME of the parts does not update.

Refer to Support Case 14017909

 

2) Use importable spreadsheet to add COST from external system to Part attribute.

Export spreadsheet from external system that contains COST info with NUMBER (same as PDMLINK)

Export Importable spreadsheet fromPDMLINK

Use VLOOKUP formula in importable spreadsheet to search external system spreadsheet for COST.

 

Formulae is not supported in importable spreadsheet, but info can be copied.

4 Comments
Level 12
Status changed to: No Plans to Implement

The system parses the values in the cells into the system - we do not interpret the spreadsheet or run any calculations.  These values should be statically saved in the spreadsheet to assure the quality of the data and that we can check the data values against system expectations.

Level 8

Why change this idea to out of scope?

 

I understand how the system works after going through the requirement with Technical Support (Support Case 14017909), but it would be much less of a manual process if formulae were supported.

Level 12

@DavidBrand the import from spreadsheet just reads values.  We do not execute or interpret the spreadsheet.  This would raise a whole series of issues for data interpretation, performance and potentially security (eg potential to run harmful code if there are embedded macros)

 

Within excel I would recommend using paste as values only to assure you are getting the values that are expected.  This will ensure greater data integrity and performance.

Level 8

@JeffZemsky thanks for the clarification.