Sign in to join the conversation:
Hi Team
Is there a way that the rows can disappear after we’ve ticked them delivered please?
Hi Trish,
You could use a filter or maybe a report to only see the rows that are relevant, but i noticed that you have something that needs to be deleted so my recommendation then would be to use a service like Zapier to move the rows to another sheet and then delete the rows from there.
Would that work for you?
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant @ Get Done
Andrée's suggestion is great! I've also done it on my own sheets where I have a top row as a Parent row with our Hierarchy function. When I am done with the next line item, I indent it, which brings it under the collapsed parent row. However, you would have to rearrange any rows that you complete that are not directly under the parent row when all child rows are collapsed. This would hide the rows instead of deleting them, but it may work for you.
I attached a screenshot just in case.
Alison
Smartsheet Support
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
I have a column named Territory, where I am trying to write a formula to populate it when names are chosen from an adjacent drop-down list column called Employee Attendee. If more than one name is selected from the Employee column, I would like their respective territories to populate in the Territory field, separated by a…
Hello, I am trying to find the average audit score for a range of percentages between two dates. There are divider rows for organization by month. I have been trying to utilize the following formula but continue to get #DIVIDE BY ZERO for an answer: =AVG(COLLECT([Audit Score]:[Audit Score], [Date of Chat]:[Date of Chat],…
