How to get the contact details for the next row using a formula?

VUnny

As part of a process I am trying to populate the next person responsible for a task and send the notification to them but struggling to get teh contact details from the row below. How do I do that?

KPH

Can you explain further what you are trying to do?

Do you want to copy the contact details from one row and use them in a cell in the row above, like this:

So that you can then use the details in an automation for the top row?

If so, the formula you need in the cell I have as Column 3, row 1 is

=Contact2

If you drag this down it will become

=Contact3 in row 2

=Contact4 in row 3

etc

The row number always being 1 number higher than the row you are on.

You will need to replace the column heading with your own heading, and if this has a space in it, use [] like:

=[Contact Name]2