Pulling Adjacent Cells


I have a column of task due dates, and an adjacent column that lists who the tasks are assigned to. In a separate column, I have a cell that shows the next upcoming due date using a formula. I would like to pull in a cell next to that the corresponding person that that next upcoming due date is assigned to. Which formula lets me show an adjacent cell to the one which the value is pulled? Aka I would like to show who the next upcoming task is assigned to.

here is an example:

due date assigned to next upcoming due date person next task is assigned to

3/1 Sarah 6/2

6/2 Ron

In this case, I would like the cell under person next task is assigned to to pull "Ron" since that corresponds with the next upcoming due date.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!