Lookup the text of a predecessor by starting with the predecessor #?

Here is what I'm looking to do…

If I flag a task as being late, I want to look at its predecessors to find the blockage. What is the easiest way to do that?

I'm sure that I will need row numbers in this solution. Let's say I have that covered (I don't). Once I have that ready. I can look at the predecessor #, go to the corresponding row, and then look up or collect the text in the task column.

That sound right to you?

Welcome ideas!

Find more posts tagged with

Formulas

Accepted answers

Darren Mullen

@Berto_DA

Yes, you have the right idea! It sounds like you just have single predecessors for each task? In that case, it is easy.

I made a video (quickly) to answer your question!

https://youtu.be/obfqWSkiI8o

All comments

Darren Mullen

@Berto_DA

Yes, you have the right idea! It sounds like you just have single predecessors for each task? In that case, it is easy.

I made a video (quickly) to answer your question!

https://youtu.be/obfqWSkiI8o

Berto_DA

Thank you very much. I'm working on this presently.

Darren Mullen

@Berto_DA

Great! I'm interested to hear how it turns out!

Berto_DA

Hello, again. This works just fine for one predecessor. Thank you. Now I'm trying to do it if there are as many as five predecessors…. Once I convert the predecessor cell to a text string…

I have to separate them to as many cells…

After that, I figure out an INDEX / MATCH…

And then use JOIN to being the text back together.

Doncha love Smartsheet!

Berto_DA

Cancel that. I figured it out!

Georgie

@Berto_DA,

Glad to hear you figured out how to do this with multiple predecessors! Would you be happy to post your solution in a comment to help other users reviewing this thread?

Thanks,

Georgie

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.