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.
Solved! Go to Solution.
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