how to use multi field formula depending on other variables

[Marina2020]

Hi,

I am trying to add a new column using Multi Field formula. I am not sure, maybe other way it will be more easier.

Here is data example:

No.	English Description	A	B	C	D	E	F	G	English Description Adjusted
1	Earphones, Half in ear,earphone30mAh	5	2	4	0	0	0	0	Earphones, Hal
2	Earphones, Half in ear,earphone30mAh	5	2	4	0	0	0	0	Earphones, Hal
3	Telephone	8	7	2	0	0	0	0	Telephone
4	Earphones	6	2	4	0	0	0	0	Earphones
5	Earphones	6	2	4	0	0	0	0	Earphones

The thing is that added new column (English Description Adjusted) depends on other 7 columns data as well as on the row level. Could someone help me to write an algorithm similar to this:

If Row +1 (column A = column B = column C = column D= column E = column F = column G) then bring value of English description (=+LEFT(B4;15)) ELSE bring value of English description.

The logic is to group goods with the same measurements. However, different english description name is needed for further analyses in order to have unique name for the same goods group with the same measurements. 

Best regards,

Marina

[RolandSchubert · Accepted solution]

Hi @Marina2020 ,

I think, you should use the Multi-Row Formula tool. I've attached a sample workflow, hope, this is helpful.

Best,

Roland 

[Marina2020]

Hi, Roland,

Thanks for your help and have a nice weekend!

Kind regards,

Marina