Sign in to join the conversation:
I want to have a condition where IF Delivered column checkbox is checked, then that whole row will be deleted. Is that feasible?
Can you please guide me how to start with it?
Hi, this would be really helpful - but not to delete the row, just to hide it please. Not sure it's possible, but...
There are a couple of ways this might be possible. If you set up a default filter on a sheet to always load rows where complete box is unchecked, then, if you checked off a task or two and reloaded the sheet those tasks would not be visible the next time it loads.
To do this:
See attached screenshot. (Right-click on the image and view in tab.
If you wanted to delete the row, you should look at Craig Williams' post on using Zapier. http://ronin-global.com/2016/12/11/smartsheet-fixed-date-upon-completion/ -- Though the post is about setting a specific date, you can use the same functionality to delete rows. It would require a paid plan for Zapier but it is possible with this tool.
Hi, I cannot see your screenshot. What was your recommendation?
This is great! Thank you so much. I have added a new filter called "Delivered"
Glad I could be of assistance. Hope its working well for you.
Hi I am tryingbuild a new Stock Control system using barcode reader on my mobile feeding into the sheets. The issue I have is adding the items up on one sheet and adding to items to another sheet to work out stock levels. I am tried using the barcode or ref no as the Lookup.
I have three columns I'm dealing with, SALARY IRA(check mark) IRA amount if the ira checkmark is checked, take SALARY *0.035 in the ira amount column
I am currently working on a construction project where I am tracking Request for Information (RFI) for our subcontractors. I can get up to 30 RFIs a day. My question is what is the best way to track how many I process daily? Is there a Countif formula or a DataMesh process that works best?
