I have a spreadsheet in Google Sheets on Mac. I would like to create new tabs in the same spreadsheet that include the rows that meet a certain criteria from a single column, which I will call the "decision column". The single decision column will contain either "Rejected" or "Complete" or be blank if the row is still in progress. One new tab would be "Rejected" one new tab would be "Complete" and one tab would be "In Progress" i.e. the cell in the "decision column" is blank for the particular row.
Ideally, it would be great if this formula could remove the complete and rejected rows out of the Master tab, and place them in another tab (In order to keep them as a record.) However, I feel this is beyond the capabilities of Google Sheets.
Once the three new tabs are set up, the idea of removing the finished rows could be accomplished with a simple "Conditional formatting" that colors the entire finished rows in the "master sheet" black (after copying it to another sheet for record keeping).
The goal here is to only have what is being worked on / the rows that are in-progress visible in the master sheet.
I have tried to use the IMPORTRANGE function, and explored the FILTER function, however I don't know how to use that to make it only copy over certain rows. This needs to happen continuously and automatically (a time delay is fine).
Best Answer
Copy and paste is tough, but you could probably do it in Apps Script. However, displaying the rows in the new tabs is absolutely the purview of the
Filterfunction.Replace the data there with your tab names, columns, and criteria.