Hi All,
I have a problem. Below I have shared 2 sample data Input and the Desired output.
I want to Create a New Field New Comment Where it will check by Request no and Name. If For a Request no It has 3 different Exception names it will check under which name in the Field Filter Criteria all the Rows are Co-ordination. It will Create a New Field New Comments and update "Coordination Hours booked" only for those names.
Note : If any of the Rows have Review or Processing for that Particular request no and has the same Exception name Then It will be Left Blank. Can somebody help me out with this ? Sample Dataset given below
Solved! Go to Solution.
@DataPirate26
Good to know.
Thank you for letting me know.
its worked