Data Trending

I am working on a project sheet. I have a cell that is made up with data that is submitted by a form. The form has around 30 different drop down items. You can only select one item from the dropdown list at a time. Here is the issue I have.

In cell "A", I might have the same text "You" listed 20 times. Then it will switch over to "Your", then this will start the next trend of data. I want to be able to move all of the data that shows "You" to another sheet as soon as I start seeing the "Your" data. Then later as I see the next trend of data "Yes", I want the "Your" data to move. This is just an example. Is it possible to do this. Thanks



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!