ke6zoy
New Member
- Joined
- May 2, 2014
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
Hi all! So I am working on a simplistic travel schedule where I'm tracking when team members are traveling for work (T days) and when they're on a customer site (X days). (I'm tracking more than 50 people for perspective)
Each week I send out an email with Columns A and B so that people can have an idea of when they're next expected to travel out to a customer sight that way it there's a surprise, they can work it with their team lead and deconflict any issues.
Is there a good way to automate column B such that it looks at the next T day listed after today's date and returns the value found in row 6? I was thinking it was kind of like a Index Match, however i think it's operating a little bit reverse.
Any insight would be appreciated.
Thanks!
Each week I send out an email with Columns A and B so that people can have an idea of when they're next expected to travel out to a customer sight that way it there's a surprise, they can work it with their team lead and deconflict any issues.
Is there a good way to automate column B such that it looks at the next T day listed after today's date and returns the value found in row 6? I was thinking it was kind of like a Index Match, however i think it's operating a little bit reverse.
Any insight would be appreciated.
Thanks!