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

(Sarvesh Mudkavi) #1

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) #2

What is the result if you try it?

(Sarvesh Mudkavi) #3

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

(Aleksi Alkio) #4

Then neither of your evaluates are true.

(Aleksi Alkio) #5

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

(Sarvesh Mudkavi) #6

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

(Aleksi Alkio) #7

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

(Sarvesh Mudkavi) #8

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) #9

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) #10

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

(Sarvesh Mudkavi) #11

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