SOLVED
Help with MultiRow Formula tool
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ssripat3
8 - Asteroid
03-13-2024
11:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
2 REPLIES 2
MilindG
12 - Quasar
03-13-2024
11:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
03-13-2024
11:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
![](/skins/images/5A278AAD67B5F68761E04A0A1AFFBB3D/responsive_peak/images/icon_anonymous_message.png)