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
I'm having an issue with this sheet: Smartsheet - Quote The COST / PC column is where the issue is happening. On line 4, I'm testing out using a different material that doesn't conform exactly to the sheet's setup but I'm trying to build in functionality to make it possible. When the columns being added by COST / PC are…
I need this formula to sum cells in a reference sheet based on dates. The reference sheet has a column with dates, and there could be multiple of the same date. I was able to get this formula to work on the top line in the screenshot, but the next line is adding the 2 week ending sums together. The planned bushels for week…
I am looking for your help once again :) So the below formula works fine for me however I have other sheets that I also need to reference. I'm assuming I would need to add an AND or OR formula to the below however I'm not sure where or what structure the formula should be. And its to reference another 4 sheets, including…
