Show the next task due

All I am trying to do is show the next task in the Next Task column that has not be marked completed in the Status Column. I tried a bunch of different Index/Collect and Index match formulas but the best I can do is get it to return a blank. I don't understand why the below formula doesn't work.

=INDEX(COLLECT([Next Task]:[Next Task], Status:Status, @cell <> "Complete"), 1)

Find more posts tagged with

Formulas

Accepted answers

All comments

Leibel S

What is it showing?

Can you show a sample of your data?

DKazatsky2

Hi @mccoy_FSI,

Check all your data for accuracy. I recreated your scenario and cut and pasted your formula and it worked immediately. It doesn't appear to be an issue with the formula itself.

Hope this helps,

Dave

mccoy_FSI

@DKazatsky2 , I see what it is. The column I am looking at has blank fields. I need this formula to look at rows that are only Task Hierarchy level 2, but can't figure it out. I am using this formula but it returns a blank, but there is a task level 2 that is not complete.

=IF([Task Heirarchy]@row = 2, INDEX(COLLECT([Next Task]:[Next Task], Status:Status, @cell <> "Complete"), 1), "")

DKazatsky2

@mccoy_FSI

Please share a screenshot(s) to show what you have. Make sure to block out any sensitive data.

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.