Smart Import using excel with formulas on cells

I.Chien

I have a question,

When I have an excel sheet which uses formulas on cells (ex. XLOOKUP…) and I want to import it to Board using SmartImport,

Is there a way to import it except change the formula to value (on excel) then do SmartImport?

Thanks for some ideas,

Willians Santana

Hi @I.Chien . I hope you are having a great day!

Thank you for your message and question! We do appreciate that.

Please let us know if the following information works for you:

• Formula.This option allows you to map the result of a formula to a target Cube or Entity code/description for each row of data submitted. You can use logical expressions in the "Formula" field, using the same syntax as algorithms. You can also use letters or the column name in square brackets preceded by an at sign (@) to refer to a specific mapped column. Example: [@Gross Sales]*2.
  Numbers in formulas must be entered in invariant culture format (culture-insensitive).
  The Formula field also supports Board's substitution formulas. If the selected substitution formula returns a text string or a date, it must be entered enclosed in double quotes. For example, the formula "@User abc" may return a result such as Paul abc.
  As with the Client filters and Fixed value settings, this mapping configuration is used to automatically write values in the selected Data model destination. For this reason, it is not displayed as a column in Play mode and no validation rules can be set on this specific source.
  Results of a formula are logged in the Smart Import log right after those submitted by the user

Interacting with the Smart Import Object

The new Smart Import Object offers an Excel-like user experience both in Design and in Play mode. 

You can select a cell or a range of cells and paste data in the selection. You can also enter data manually, either by double-clicking on a cell and typing the desired value or by selecting a single cell and typing data.

The Object also supports formulas and functions to make complex and useful calculations before loading the data Cubes/Entities: formulas and functions always begin with the equal sign "=" and are built using the same syntax and operators used in Microsoft Excel.

https://www.boardmanual.com/2021/summer/whats-new-release-notes/2022-summer-release/main-features/smart-import-object.htm?rhhlterm=smart%20import%20imported%20object%20objects&rhsearch=smart%20import%20object

We are all ears for you!

Kind Regards,

Willians