Giving Remark based on specific condition

SH_94

Dear community,

I would like to ask how do we build the formula below :

1. If the " Tracking Number column" showing the same number wih the following row and the "month column" showing same number with the following rows , then we give remark as "yes" for the first row under the " Check column" and give remarks as " No" for the followng row under the "Check column"

2.If the " Tracking Number column" showing the same number wih the following row but there is missing detail "month column"  , then we give remark as "yes" under the " Check column" for the row containing detail and give remarks as " No"

for the row that does not have the detail.

3.If the " Tracking Number column" showing the different number wih the following row and there is missing detail "month column"  , then we give remark as "no" under the " Check column".

Thank you.

Tracking.xlsx

Luke_C

Hi @SH_94 

A multi-row formula tool should do the trick:

if [Row+1:Tracking Number] = [Tracking Number] and ([Row+1:Month] = [Month] OR isempty([Row+1:Month])) then 'Yes'
Elseif !isempty([Month]) and [Row+1:Tracking Number] != [Tracking Number] then 'Yes'
else 'No'
endif

New Workflow9.yxmd