Welcome!

Formula help on IF ELSE

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?

Find more posts tagged with

Manufacturing

Formulas

IT & Operations

Comments

Lisa-B

Hi, this would be really helpful - but not to delete the row, just to hide it please. Not sure it's possible, but...

Mike Wilday

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.

Mike Wilday

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.

trishhfernandez

Hi, I cannot see your screenshot. What was your recommendation?

trishhfernandez

This is great! Thank you so much. I have added a new filter called "Delivered"

Mike Wilday

Glad I could be of assistance. Hope its working well for you.

Sign in to join the conversation!

Quick Links

Trending discussions

Week Number Year to Year
I've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
Use Sheet Summary as cell reference for a different sheet
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
Issues with IF formula
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…