we have a lot of tasks and subtasks in our smartsheet.
When we are talking about a specific topic, we would like to filter this topic (task) and all of his subtasks from the cardview.
Any idea how to do this?
I created a column called Topic and added that to the top level item. Using Single Select you can show these in the card as the top level and then use the filter.
If you choose multiselect because a task has more than one, you will not see it as a "View by Topic" but using a filter will still show you those that have the criteria. Then you can click on the sub tasks and that then shows them to you.
Hope that helps
Your Time is Important, you want to Stay on Track, We can help you use the Right Tools
I'm not sure, if I understand your suggestion and sorry, english is not my native language :-(.
To clearify my request I try to give an example:
I select the task "budget planning" and would like to have this task and his subtasks filtered and displayed. Not showing any other task.
I do not understand the sense of the column called Topic?
What does "Single Select" mean in the card view?
Thank you very much for your kind help, Joachim
That's a great idea! While the ability to automatically filter out tasks isn't available in Smartsheet at this time I would recommend submitting a request to our Product team for this feature, for possible future production!
In the meantime, @Cierr's solution will allow you to re-order the cards based on their Main Task row. However, this method will require that a new "View By" column is added to your sheet while in Grid view. This new column should be listed as a Single Select Dropdown type column with "Values" as the primary task for each of your sections. Once this is in place, you would then want to list the primary task value on all rows (cards in card view) that are part of this group (tasks and sub tasks).
Then in Card View, update the "View By" section to view by your new dropdown ("Topic") column to see each hierarchy section in different Lanes of the Card View. More on working in the Card View can be found in our Learning Center Here.
Alternately, creating a Filter that can be applied to the sheet that uses a common feature of the indented sub tasks could also be used to hide additional tasks and sub tasks. Check out our resource on Filters for more!
Hello! I created two sheets with separate forms and when I checked to see if anyone had submitted the forms yet, I didn't see anything on either sheet but when I click on "manage forms" it says that there are 62 submissions for one and 18 for the other. How can I fix this so I can see what people are submitting?! Thank…
I have a Smartsheet tracker that has been tied to one report. I recently created a second report that pulls similar information from the same Smartsheet tracker and that is working fine. However, the other report no longer shows any data in it for me or others. I have verified that we have admin access on the original…
39 submissions isn't accurate because many of them were just tests. Currently have 3 submissions and would like for it to show 3, is that possible
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.