I am trying to make a workflow where the robot is able to find the earliest date within a group and paste in the data to a row when it finds it.
This is table A:
it is used as reference to find a group in Table B and we will paste the value from Table A according to their group
This is my table B:
I want to plug in values inside this table based on the earliest date it can find within a group. For example the earliest date in group B is 12/22/2018 and the robot will paste in the value from Table A in ‘Values’ column Table B in that row.
This is how the outcome should look like:
I have tried to develop the workflow but I couldn’t seem to figure out the logic. My current workflow is working fine without any errors but it doesn’t seem to update anything on the Table B file.
Compare and plug in.zip (25.5 KB)
this is my initial workflow look like for the date comparison part.
I’m sorry if my explanation are unclear English is not my strongest suit