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?