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 |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |