Welcome!

Filter/remove closed tasks

One of the columns in my smartsheet is labelled 'Status' and fields are completed using a drop down menu. The corresponding rows are a list of tasks.

One of the drop down options for status is 'closed' (for when a task is completed).

Is there a way of filtering the list of rows to remove these 'closed' tasks?

Ally

Find more posts tagged with

Comments

Andrée Starå

Hi Ally,

Filters or reports would work great for this.

You could add a filter on the sheet to only show the incomplete tasks.

https://help.smartsheet.com/articles/504659-using-filters-to-show-or-hide-sheet-data

https://help.smartsheet.com/articles/522214-creating-reports

Would that work for you?

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

abradley

Hi Andrée

That is just perfect! Exactly what I was looking for. Thanks so much for your help.

Allyson

Andrée Starå

Happy to help!

Have a fantastic weekend!

Best,

Andrée

abradley

Is it possible to add a comment to a column rather than a row? I have a smartsheet that has project names as the rows and some of the column headers are time points with the content being the time taken in days. I want to add a comment to the column headings to explain how the time points are calculated (e.g. number of days from 1st review date to final sign off date).

I can only find a way to comment on the whole row.

Thanks for any help!

Andrée Starå

Hi,

Unfortunately, there isn't a comment function for the columns, but a possible workaround could be to use the first row to add that information and maybe hide it with hierarchy so that it's just visible when the user want's to see it. I do this all the time for instructions, KPI's and more.

Would that work for you?

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

abradley

Thanks so much for your help - that would definitely work!

Andrée Starå

Happy to help!

Sign in to join the conversation!

Quick Links

Trending discussions

How to create stack column graph bars
I'm trying to create a graph chart that captures monthly count of records by divisions (Northeast, West and Central) that should be stacked with a legend displaying each by different color like a presented in Excel. When I attempt to duplicate the process in Smartsheet I receive the following results. In Excel, I created…
Linked Dropdown Columns
Good afternoon, I am trying to utilize Linked Dropdown Columns for a manual process we have. We have many sheets that use a "Client Name" column with a dropdown list. Whenever a new client comes on or exits, we have to manually update every sheet that has a Client Name column and update the dropdown list. We do not have…
How do the automated notification attachment triggers work?
This should be straightforward information but I can't find it anywhere. How do the Automation triggers work for attachments? I assumed: An attachment is Added = New attachment An attachment is Changed = New version of existing attachment. But I just had an 'Added' attachment notification trigger when I uploaded a new…