Is there an option to move a row to another Sheet based upon a particular selection from within a dropdown menue or checkbox within a form? For example, we have created an Status Column in Column A with a dropdown menu of Pass or Schedule Interview. If we select Pass, we would like to remove that candidate/row however, we don't want to delete the candidate/row so we thought it would be nice if we could move them to another sheet for future reference. Is there an easy way to do this or any suggestions to accomplish this? I know copy past doesn't work unless you have the exact number of columns in the other Sheet and there is no Hide option for rows. Any feedback is appreciated.
Have you try to play with filters? You could "hide" all rows with "Pass" and show the rest. This way no information is lost (remove the filter to see all rows again).
Or use Sort to show all the rows with "Pass" at the end of the table...
You can also use sort and filters to group the rows you want to copy and paste (in Excel or new table in FormsCentral) then delete the rows from your response table.