|
Post by KB on Oct 13, 2016 14:00:25 GMT
Hi Peas,
At work we use a Google Sheet to track customer service issues. I'd like to have a row of data automatically moved from the sheet named 'OPEN ISSUES' to the sheet named 'CLOSED' when a cell (for example A1) is changed from "Open" to "Closed".
Do you know if this is possible to do in Google Sheets? I've looked around on the internet but haven't had much luck.
Thank you!
|
|
|
Post by JustCallMeMommy on Oct 13, 2016 14:13:03 GMT
I doubt it. You could do it in Excel using macros, but I don't think that is an option in Google's spreadsheet. I would probably keep one spreadsheet and use filtering to see just the data I need.
ETA: After a little googling, there is a way to do the equivalent of a macro using Google Apps Script, but we've officially left my area of expertise.
|
|
|
Post by KB on Oct 13, 2016 14:14:21 GMT
I doubt it. You could do it in Excel using macros, but I don't think that is an option in Google's spreadsheet. I would probably keep one spreadsheet and use filtering to see just the data I need. That is exactly what I was thinking but hoping that I was wrong! Thank you!
|
|