Is this possible to do....
- I want to have a master call log for incoming service requests, with a status column. I will set an automation to copy the row to another sheet I will use for task tracking.
- Once I have completed the task and change the status on the 2nd sheet, I want to cell link so it also changes on the master log. The caveat is, once I have completed the task, changed the status and saved it, I will no longer need this row on the 2nd sheet. So, once the status is changed, I want that linked back to the master log, then that row on the 2nd sheet to go away.
- is this possible to do????