Filter on sheets or report criteria
Can I create a filter on sheets or reports, which includes "assigned to" a certain individual and also, show the dependency line? If a Task is assigned to "A" and there is a dependency (Predecessor) on Line #5, then filter on A and show Line #5 also.
Answers
-
Hi @divyaj22
Filters in a Sheet or Report are only looking at the data on each individual row; there currently isn't a filter that will automatically bring in associated predecessor rows.
You could potentially use a formula to bring into your Predecessor row the Dependent row data, in order to use that in a filter. This would be in a new Contact column.
First, I would use the SUCCESSOR function to bring back the row number of the successor row for this current Predecessor:
=VALUE(JOIN(SUCCESSORS([Task Name]@row), ","))
You'll notice I wrapped it in a VALUE function to ensure the row number comes back as a number. This will only work if you have single dependent rows (e.g. none of your predecessors have multiple dependents)
Then in the new Contact column you can use this row number as the reference for what to Index:
=IF(Sucesssor@row = 0, "", INDEX([Assigned To]:[Assigned To], Sucesssor@row))
Now you have a Contact in the current row that you can use for filters! 🙂
Cheers,
GenevieveNeed more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives