Pulling Adjacent Cells
Hello,
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.
Thanks.
Best Answers
-
@Paul Newcome what should go in the COLLECT parenthesis?
-
You would replace
MIN(COLLECT(...............))
with whatever your existing MIN/COLLECT formula is to pull the date.
Answers
-
Hi @Danielle Ferrari
Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.
Or if you like to fix the formula directly on your sheet please share me as an admin on a copy of your sheets ( Source & Destination ) and i will write the exact formula for you then you can copy it to your original sheet.
My Email for sharing : Bassam.k@mobilproject.it
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
I hope you're well and safe!
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Here is the spreadsheet. I used a =MIN(COLLECT formula to calculate the nearest upcoming due date, and I would like to pull the person that it is assigned to along with it somehow so it will go under "Upcoming Assigned to" @Andrée Starå @Bassam Khalil
-
I would suggest something along these lines...
=INDEX([Assigned To]:[Assigned To], MATCH(MIN(COLLECT(..............)), Finish:Finish, 0))
-
@Paul Newcome what should go in the COLLECT parenthesis?
-
You would replace
MIN(COLLECT(...............))
with whatever your existing MIN/COLLECT formula is to pull the date.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!