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)
What is the result if you try it?
I’m getting blank in google sheet as well as in appsheet
Then neither of your evaluates are true.
What do you want to acchieve with this one… [_THISROW].[ENEM LR]?
Actually i wanted to get "YES"in merge column,if enem lr column has same values
Do you mean your whole table has the same value than the value in this one record?
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
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”?
You probably need a formula like… IF(ISBLANK(SELECT(TableName[KeyColumn],[ENEM LR]=[_THISROW].[ENEM LR])),“No”,“Yes”)
I will segregate the No rows and yes rows ,and thank you Aleksi Alkio the above formula works
User | Count |
---|---|
42 | |
29 | |
22 | |
20 | |
15 |