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,
Genevieve
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives