Multi row function

[NandeeshGowda]

Hi there,

I am new to Alteryx Designer. I am trying to build a workflow to process a cell value based on 2 different values. It's a monthly work schedule for employees I need to identify a day type if it's first of the roster (after the weekend) or the last day of the roster and before a public holiday and after the public holidays. 

Thanks for your help!!

Gowda

[fmvizcaino]

Hi @NandeeshGowda ,

Here is a suggestion for you. It is not finished, you would probably need to create some more conditions in the last formula to fill the cases where it is after PU/After WE.

Best,

FErnando Vizcaino