22.214.171.124 Import Data & Add Formula
Can someone help me figure out what formula I need here? All the columns are filled. What am I missing?
Check out these two links. They should help.
Thanks for this! I understand the concepts but I am still struggling with this specific problem.0
Not sure I understand what your question is. Can you clarify? The images don't seem to help me.0
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?1
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.0
Also, are you sure that is the correct code for the combination list?0
This is why I asked this question. I am not sure. The code was imported from the CSV file given.
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.0