Help with MultiRow Formula tool

[ssripat3]

 Expected Input

Expected Output

Hello Community,

I am trying to use Multi Row Formula tool to check if a value in Replaces column is not empty. In this scenario, I would like to take the Part Number value and place it in the row above in the column Replaced By.

Any suggestions appreciated and the sample data is available in the yxmd file attached below and thank you for the help.

[MilindG · Accepted solution]

@ssripat3 

[ssripat3]

I was able to do it another way.

IF IsEmpty([Replaced By]) AND !IsEmpty([Row+1:Replaces]) THEN
[Row+1:Part Number]
ELSE ""
ENDIF

I used this formula directly in the Multi-Row formula tool