Timeline view and multi-value fields
Hello All,
I really like the Timeline view based on a start & end date but am hitting a wall trying to show a similar but slightly different perspective. I have a list of projects (each one row) and one of the fields is a multi-valued field of team members who are working on that effort.
Is there a way to get the project to appear for each person that appears in this field using Timeline view?
For example, Jane and John are assigned to project Happy. I would like to use the Timeline view to show John assigned to project Happy for the duration of the effort. Similarly, I would like to see another row for Jane for project Happy for the same duration. (Essentially, show the info for each person assigned to the project team)
This works for any grouping that is single valued but does not even appear as a choice if multi-valued.
Any thoughts or suggestions is much appreciated.
Thanks.
Answers
-
You answered your own question…
"This works for any grouping that is single valued but does not even appear as a choice if multi-valued."
-
Well, OK if that is the way it works.
Any thoughts of a workaround? I can work it out in my head using SQL but obviously can't do that in Smartsheet.
Open to any thoughts or suggestions.
Thanks.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives