Populate one row below a specific row

[daraghwalker]

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'.

[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

[atcodedog05 · Accepted solution]

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 : )

[atcodedog05]

Happy to help 😃 @daraghwalker 

Cheers and Happy Analysing 🥳 🥳