Dynamically Gathering Cell Data's

[arjundelara]

Hi All,

I have a static workflow that gather data based on the range I set. but I want it to gather data based on the data in last row of column. My example excel

I'll set the header to the Debit Sample data and gather the data below and will stop getting data if there is a blank below to the last row of data gather or It will stop if I set that if the word like this is gather the gather of data will stop. So It means it will be a dynamically getting data below on the Debit sample Column and I will not set the range of getting the records.

This is my Sample Static Workflow

Is there Anyone can help me to make it Dynamic.

" Last row of Data or Setting the word if gather then Stop"

Regards,

TIA.

[MichalM · Accepted solution]

@arjundelara 

I'd use the Multi-row Formula module to achieve this. 

Here's the data

You can build the logic that you've described using the below expression - I'm creating a new field - Select - with a Yes/No flag

IF IsEmpty([Field2]) THEN "No"
ELSEIF [Row-2:Field2] = "Debit Sample" THEN "Yes" 
ELSEIF [Row-1:Select] = "Yes" THEN "Yes"
ELSE "No"
ENDIF

Example attached

[arjundelara]

Hi @MichalM ,

Highly Appreciated. This is Great !

Thank you!