1.4.3.2 Import Data & Add Formula

sydneygouani
Contributor

1.4.3.2 Import Data & Add Formula

Can someone help me figure out what formula I need here? All the columns are filled. What am I missing?

8 REPLIES 8
chofacker
Contributor
sydneygouani
Contributor

Thanks for this! I understand the concepts but I am still struggling with this specific problem. 

chofacker
Contributor

Not sure I understand what your question is. Can you clarify? The images don't seem to help me. 

sydneygouani
Contributor

The directions asked me to make a new module to import all the data. Then it says to create a formula for the "Code" column. I am not clear why I am making a formula because the "Code" column is filled. Can you give me some insight as to the logic behind adding a formula? Where do I start?

FahuaXu
Occasional Contributor

Thank you @chofacker! Combined with CODE() and Item() syntax, the answer to this question should be CODE(Item(SKU Flat)) and it works for me.

ChrisAHeathcote
Community Boss

@sydneygouani 

If you recall from Level 1 there is a formula that can be used to derive the code of the list which is dimensioned in the module.

Use this combination of CODE and ITEM functions to return the code.

Chris
HeathcoteAndHerran.com
ChrisAHeathcote
Community Boss

Also, are you sure that is the correct code for the combination list?
Chris
HeathcoteAndHerran.com
sydneygouani
Contributor

This is why I asked this question. I am not sure. The code was imported from the CSV file given.

 

I