Auto delete data from a cell once triggered?

Hi does anyone know if there is a way to delete data in a cell once that cell is triggered using a Zap? I was directed to Zapier, but man...I'm a newbie there. Has anyone done something similar?

Basically -- am using a ranking system to prioritize projects. Once projects are prioritized, I would like to pull them out of the ranking system, so they aren't continuously in the mix. I realize we can filter them out, and we could also split the sheets into 2, but our preference is to keep it all in one sheet.

Here is a screen shot --

When I click the star indicating the project idea has been prioritized, I want that data to be pulled out of the ranking column so it is no longer considered in the rank stack.

Any Ideas?

Find more posts tagged with

Formulas

Workflows in Smartsheet

Accepted answers

All comments

Andrée Starå

Hi @Amy Scherer

What if you add a condition to the formula to be blank if the star is selected?

If that doesn't work, it is possible with Zapier, but I'm not sure it will work with the new Column Formula feature, so we might need to add a so-called helper column.

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.