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?
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives