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!!