append cell using multi-row formula

[prthmesh111]

Hi , 

can someone please help me out in below example of the table using multi-row formula any other way

if number = row+1:number then

if date != row+1:date then "date mismatch"

else if value! = row+1": Value " value not match"

else "" end if

else "" end if

in the comment section it should show both the conditional value,

but currently showing single value

Number	Date	Value	Comment
1234	12/02/2020	100	Date mismatch. value not match
1234	13/02/2020	500	Date mismatch. value not match
1235	14/02/2020	600	Date mismatch. value not match
1235	15/02/2020	700	Date mismatch. value not match

[patrick_mcauliffe]

@prthmesh111 Can you please post what you've tried so far so no one tries something you've already done?

[prthmesh111]

using multi-row formula, i first check if number of first row is = to number of next row then

first i check if date of first row != date of second row then i put "date not match"

else_if value of first row != value of second row then " value not match"

else " "

end if

end if

so i want that Comment to be date not match, value not match

but currently i am getting only date not match 

[ArtApa · Accepted solution]

Hi - I think this is what you're looking for:

if [Number]=[Row+1:Number] then
iif([Date ]=[Row+1:Date ],"","Date mismatch. ") + iif([Value]=[Row+1:Value],"","value not match")
else ""
endif

I attached my workflow for your reference:

The first Multi Row is your condition. The second is to fill the gaps.

[prthmesh111]

Thanks for the solution

[sgwong]

Need assist to get the below output.