Hello Geniuses,
I have a roles in a column wherein i have blanks after every 2 rows. All i'm checking is there has to be preparer and reviewer combination in each pair and NOT preparer-preparer or reviewer-reviewer combo. If so, all i need is 'good' to be populated in check column, here is the table
Role | Role check |
(null) | |
Preparer | good |
Reviewer | good |
(null) | |
Preparer | good |
Reviewer | good |
(null) | |
Preparer | good |
Reviewer | good |
Solved! Go to Solution.
hi @ilovecoding
Multi Row formula can solve your case.
Though not mentioned in your post, I put "Not good" when condition is not met.
Thank you very much
Hey i applied the same logic to my another column where i m comparing sentences, basically a one liner. What i noticed is for majority of times it is giving me correct output as 'not good' for those where 2 lines are exactly identical, however for few it is giving me 'good' where both the lines are identical. Would you know why ?
see below, xxx is nothing but sensitive data.
Sanctioned xxx . Actual maturity date mm/year . xxx and xxx still reflect holdings. | Preparer | Good | good |
Sanctioned xxx . Actual maturity date mm/year . xxx and xxx still reflect holdings. | Reviewer | Good | good |
hi @ilovecoding *If possible, please mention like @XXXXX so I can receive notification, otherwise I would miss it
Can you change configuration of Multi Row Formula like this, and check the result again?
Values for Rows that don't Exist
0 or Empty => NULL
@gawa - tried, didnt work :(
@ilovecoding Can you provide more sample data so that I can reproduce your issue at my end?
@gawa Here is the table with the outcome i need in last 2 columns. For comments its working for majority but not for some.
Comments | Role | Comment check | Role check |
A for apple. | Preparer | Not good | Good |
A for apple. | Reviewer | Not good | Good |
B for ball. | Preparer | Good | Good |
C for cat. | Reviewer | Good | Good |
If comments are same its 'not good'
If comments are same it would be no good, also each such lines has one blank line on top.
Comments | Role | Comment check | Role check |
A for apple. | Preparer | Not good | Good |
A for apple. | Reviewer | Not good | Good |
B for ball. | Preparer | Good | Good |
C for cat. | Reviewer | Good | Good |
D for Dog. | Preparer | Good | Good |
R for Rabit | Reviewer | Good | Good |
J for Joker. | Preparer | Good | Good |
M for Monkey | Reviewer | Good | Good |
N for nose, Z for zebra | Preparer | Not good | Good |
N for nose, Z for zebra | Reviewer | Not good | Good |