Multi Row Formula

[wonka1234]

Hi,

Trying to get my multi formula tool working, I am trying to just select all data from "SERIES" to the first "TOTAL"  in the series column or column A.

Then I would use the select column to filter for the rows I want only (from series to total). 

I am expecting 1's beside all the CM rows so I can filter for them only.

Anyone help with this?

[IraWatt]

Hey @wonka1234,

Would you be able to provide some sample data so I can see where your formula needs changing. Currently the CM rows wont be 1 because your searching the series row above for the word "SERIES" and they are "CM". 

[wonka1234]

@IraWatt 

Hi,

ive attached a sample workflow with the data.

Thanks.

[IraWatt · Accepted solution]

Hey @wonka1234,

I have attached what I think you were looking for. 

if LEFT([SERIES],2) = "CM"  then 1 
elseif [SERIES]= "TOTAL" then 0
else [Row-1:Select] endif

The first line checks if the current rows series first two letters is CM if yes then apply 1. It will keep Applying 1's till the first Total.

[wonka1234]

@IraWatt 

Thanks!

What is Series wasnt imported at the first line/header? 

Would it be possible to fix that so that SERIES line is the header? 

[IraWatt]

@wonka1234 try this:

if LEFT([SERIES],2) = "CM" OR [SERIES] = "Series"  then 1 
elseif [SERIES]= "TOTAL" then 0
else [Row-1:Select] endif

[wonka1234]

@IraWatt  with your first mockup file, can totla have a "1" beside it aswell? I want to include TOTAL.

[wonka1234]

@IraWatt 

I want the first "TOTAL" to have 1. everything after 0.