Formula help on IF ELSE
Comments
-
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:
- Create a new filter.
- Title it and check the Share Filter checkbox
- Set the criteria to the checkbox is unchecked
- Then click okay
- Save the sheet to save the shared filter.
- Click on SHARE
- Scroll down and click edit next to the default view
- Set the filter to new filter you saved
- Save.
- Check off some boxes and save the sheet.
- Reload the sheet and the completed items will not be visible.
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!