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)
Answers
-
What is it showing?
Can you show a sample of your data?
-
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
-
@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), "")
-
Please share a screenshot(s) to show what you have. Make sure to block out any sensitive data.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!