Am I doing Wrong? I want to get "merge" colu...

[Sarvesh_Mudkavi]

Am I doing Wrong?

I want to get “merge” column as yes,when the values of “enem lr” column are identical.

In appformula of merge column,i’ve inserted the below formula

IFS( ISBLANK([ENEM LR]),NO

[ENEM LR]=[_THISROW].[ENEM LR],YES)

[Aleksi_Alkio]

What is the result if you try it?

[Sarvesh_Mudkavi]

I’m getting blank in google sheet as well as in appsheet

[Aleksi_Alkio]

Then neither of your evaluates are true.

[Aleksi_Alkio]

What do you want to acchieve with this one… [_THISROW].[ENEM LR]?

[Sarvesh_Mudkavi]

Actually i wanted to get "YES"in merge column,if enem lr column has same values

[Aleksi_Alkio]

Do you mean your whole table has the same value than the value in this one record?

[Sarvesh_Mudkavi]

Please check the below screen shot for what i’m trying. I want to get yes in 1 col if some col has same values

[Aleksi_Alkio]

Okay… you want to compare two rows (records), not columns. Then what happens if you have more records than one already in your table and your values are like “No, No, Yes, No”?

[Aleksi_Alkio]

You probably need a formula like… IF(ISBLANK(SELECT(TableName[KeyColumn],[ENEM LR]=[_THISROW].[ENEM LR])),“No”,“Yes”)

[Sarvesh_Mudkavi]

I will segregate the No rows and yes rows ,and thank you Aleksi Alkio the above formula works