Multirow Formula

[noopurjain]

Hello,

I have been trying to copy "ID" field from above to below when account number is same. Please see column " need this Output" for reference.

I have created this in multirow formula but it isn't working:

IF isnull([ID]) and [account]=[Row-1:account] THEN [Row-1:ID] ELSE NULL ENDIF

[atcodedog05 · Accepted solution]

Hi @noopurjain 

Here is how you can do it.

Workflow:

Hope this helps : )

[noopurjain]

Thanks  @atcodedog05

[atcodedog05]

Happy to help : ) @noopurjain 

Cheers and have a nice day!