Formula Help

[jordanmount6]

I want to have a new column that will say "Yes" if there is a "Y" value between the start and end date in the parsed columns. I've added an attachment that will hopefully make more sense. 

[mceleavey]

Hi @jordanmount6 ,

can you please post that data so we don't have to manually create it?

M.

[jordanmount6]

Here it is in an excel file

[Felipe_Ribeir0]

Hi @jordanmount6 

One way of doing this (it is the Max_Value column):

@mceleavey , maybe you find this resource useful to transform images to tables (i used it here for this case, there are similar ones out there): https://www.extracttable.com/

[jordanmount6]

Thank you for responding. This gives a "Y" value to every single record though because there is at least one Y in every single row. I only care about the "Y" if its between the start and end date though. 

[Felipe_Ribeir0]

Hi @jordanmount6 

Please see if this make sense for you:

[ShankerV]

Hi @jordanmount6 

Please find the expected output.

Many thanks

Shanker V

[BS_THE_ANALYST]

Hi @jordanmount6. 

Based on the criteria you gave, all were labelled as 'No':

Changing the criteria (start/end date) to check if it works ..

Workflow:

[jordanmount6]

How would i account for multiple start and end dates? 

I could have 5 possible start/end dates