Populate one row below a specific row

Hi, I am having trouble with the Multi-Row Formula tool as when I run it, it seems to populate all rows below a specified row value rather than just one row below.

In this instance, I would like to populate row 2, 5 and 10 with 'True' since row 1, 4 and 9 contain 'True'.

Workflow

Preparation

Accepted answers

atcodedog05

Hi @daraghwalker ,

Here is a workflow for the task.

Input : data provided

Output :

Workflow

Us this formula in Muti-Row formula. Field option update field.

IF isnull([Field1]) and !isnull([Row-1:Field1]) 
and [Row-1:Field1]!=[Row-2:Field1]
THEN [Row-1:Field1] ELSE [Field1] ENDIF

Hope this helps : )

If this post helps you please mark it as solution. And give a like if you dont mind : )

Multi.yxmd

All comments

jdunkerley79

I would suggest:

IIF(IsNull(Field1) AND [Row-1:Field1],1,[Field1])

with the Multi Row Formula tool to create a new Field2 and then a Select tool to swap it for Field1

Have attached a sample

Field1 Rewrite.yxmd

atcodedog05

Hi @daraghwalker ,

Here is a workflow for the task.

Input : data provided

Output :

Workflow

Us this formula in Muti-Row formula. Field option update field.

IF isnull([Field1]) and !isnull([Row-1:Field1]) 
and [Row-1:Field1]!=[Row-2:Field1]
THEN [Row-1:Field1] ELSE [Field1] ENDIF

Hope this helps : )

If this post helps you please mark it as solution. And give a like if you dont mind : )

Multi.yxmd

atcodedog05

Happy to help 😃 @daraghwalker

Cheers and Happy Analysing 🥳 🥳

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703