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 looking for a way that if the Status column is changed to "In Progress" it will change the the start date to that date. However, I only want it to change when switched to in progress. Also, I don't seem to be able to do this with a Gant table.
Please see formula below - when the planned date is less than the due date and inside the same month it shows as 'N/A'…. when the planned date is greater than either the actual day/date or the month in the due date of next inspection column it shows as 'Yes' in late booking column - when the planned date is less than the…
I had a formula to list all distinct values from a column in another sheet. I was using this formula and it was working fine until last week. What could be wrong? =IFERROR(INDEX(DISTINCT({Liste de matériel Plage 1}); Séquence@row ); "") When I remove IFERROR, I get #INVALID DATA TYPE
