Hello.
I have product titles which are generated by combining quantity per set, color, and finish.
So far, I have managed to write an IF nested formula for the color & finish scenarios:
{IDENTITY_Parent Product Name}&IF(OPTION_Color=BLANK(), ‘, ‘&OPTION_Finish&’ Finish’, IF(OPTION_Finish, ‘, ‘&OPTION_Color&’, ‘&OPTION_Finish&’ Finish’, IF(OPTION_Color, ', '&OPTION_Color)))
However, I would like to add a scenario at the beginning, that IF the “SET OF” field is >1, it will then write ‘Set Of {Set of}’ right after the {IDENTITY_Parent Product Name}.
For that part, I wrote the following:
IF({FEATURES_QTY Per SKU}>1, {IDENTITY_Parent Product Name}&’, Set Of '&{FEATURES_QTY Per SKU}
The challenge I am having is that any way I tried to combine either I would get an error, or it would stop reading if it found the Set Of >1, whereas I want the formula to not stop reading there but continue on and apply the rest of it to have a result where we could read:
Moxy Sheets, Set Of Two, Blue, Satin Finish
Or
Moxy Sheets, Blue, Satin Finish
Thanks!!