Multi Row Formula

[Jerin_jaj]

I want to update an existing flag column based on its active row value. 

if flag=1 then [row-1:flag]=1 else [flag] endif. 

When i am trying this, all values are turning 0. 

Please Help

[LordNeilLord]

Hey @Jerin_jaj 

By saying "[row-1:flag]=1" you are actually creating a boolean (true/false) which is why you get 0 as the answer, try modifying to this:

if flag=1 then [row-1:flag] else [flag] endif. 

[Jerin_jaj]

 tried the formula but still getting all 0.

[LordNeilLord]

@Jerin_jaj 

Can you screen shot or provide your workflow?

[Jerin_jaj · Accepted solution]

i tried row+1 instead of row-1 and its working perfectly as required.

if [Row+1:Flag]=1 then 1 else [Flag] endif