Multirow formula - If statement

[SomeshN]

Hi All,

I am trying to apply a multi row formula with if condition on existing column.

If the condition is met than the desired result should be on Row-1 and Active Row both e.g. below

IF [Row-1:Unique ID]=[Unique ID] then "Out" else "In" endif

with above expression the 'Out" result only appears on active row and Row-1 gets "In" however the desired result is "Out" on both the rows.

Can anyone help please

[Luke_C]

Hi @SomeshN  - please provide some sample data with expected results. Also share the configurations of your multi-row tool, might have to do with your 'values for rows that don't exist'

[ArtApa · Accepted solution]

Hi @SomeshN - You will need two tools, as with Multirow you can update only one row. See attached example.

[SomeshN]

Thank you, it worked!!