Google Sheets SKU automated data
I'm looking to create a CSV that automates product colour and size variables (Columns I and K, highlighted yellow and blue) based on the value I put in the SKU (Column N, highlighted green).
I would like to create a SKU (Column N) that looks similar to 1-5 which would have the output of Blue (Column I) and 5 (Column K).
Another example of this could be 2-11 which would have an output of Red (Column I) and 11 (Column K).
The aim of this is to automate the process by assigning each colour and shoe size with it's own value to save the client as much time as possible.
Any help with this would be greatly appreciated.
Link to CSV https://docs.google.com/spreadsheets/d/1lc8XcHDMyMFGAkegTRrBLLTlQN8oNVbU430vT0aeP4Y/edit?usp=sharing
I1: =arrayformula(if(A1:A="Handle","Option1 Value",IF(LEFT(N1:N)="1","Blue",IF(LEFT(N1:N)="2","Red","Green"))))
K1: =arrayformula(if(A1:A="Handle","Option2 Value",IF(LEN(MID(N1:N,3,3))>2,LEFT(MID(N1:N,3,3),2)&"."&RIGHT(MID(N1:N,3,3)),LEFT(MID(N1:N,3,3),2))))
- What is wrong with this code for creating lists in OCaml?
- Run a function inside a function
- Have a function take some data and send it back
- How to determine whether a function exists in a POSIX shell?
- Simplest/cleanest way to implement a singleton in JavaScript
- What is the difference between a "function" and a "procedure"?
- Is there a limit to the number of arguments passed to a fortran function?
- 2 Functions in 1 main program(Visual Studio 2013)
- When I modify a parameter inside a function, why does the variable passed as the argument not change?
- What is a non-local return?
- Using a class to open same popup using document.querySelector
- Is `std::function` deprecated by `std::copyable_function` in C++26?
- Is there a JavaScript function that reduces a fraction
- How apply a function to every element of a matrix?
- Dynamic function name in JavaScript
- Why are class member functions inlined?
- How to create unique slugs from unique integers?
- How to get slugs and names of all order statuses in WooCommerce?
- Outer function returning multi-line values with the help of refcursors
- PHP Call to undefined function
- Computing the cross product of two vectors in Fortran 90
- I keep getting AttributeError: 'Toplevel' object has no attribute 'addtolist' when trying to call functions inside my toplevel class
- Simplify a Powershell one-line function that works with pipelines as well as conventional parameters
- javascript jquery function is this somehow wrong?
- Compare two arrays of objects, and remove if object value is equal
- error compiling in c user input
- How can I deploy cache when the order of arguments doesn't matter?
- C - function inside struct
- Automatically assign products to categories based on their product tags in Woocommerce
- R commands behave incorrectly when converted to a function: failed evaluation of variable in for loop