Multi-row Formula Question

Hi everyone,

I'm trying to create a mapping file based on if the TM Column has an A in it and make all the rows above that equal that output as well. So I did

IF [TM]="A" THEN [Account] ELSE [Row-1:Mapping] ENDIF

As you can see based on the attachment it is skipping my first set of data which is making the entire output be shifted down which is wrong. I understand this is because I'm doing Row-1 and it is taking the first active row but when I try Row+1 it is saying it doesn't exist so I'm wondering if anyone knows a way around this?

Workflow

Common Use Cases

Accepted answers

I get what you mean. Here's an alternative:

- Add a Record ID

- Sort your data by Record ID descending (reversing the order of your data)

- Use the Multi-Row formula as you did

- Sort the data back

Cheers,

All comments

How does your original data look like?

I think if you set this option to be true - "Set to Values of Closest Valid Row", it will work well.

Cheers,

Hi,

I tried that and it still leaves the top blank. Attached is the original data

Hi @kdelisi002 ,

This looks like it produces the mapping file you were looking for.

Multi Row Help.png

Multi Row Help.yxmd

Quick Links

Tags

This months top contributors

Hollingsworth 335