In trying to help a team member, I was curious if I can even accomplish this task.
She currently enters data in a spreadsheet either daily or every other day, tracking clients. I've recently made another spreadsheet for our medical team to provide "live" data through teams on whether or not our transporters picked up a client.
So my question is, is it possible that if a transporter selects yes next to a client, is it possible to call out to the other spreadsheet confirming that day (of pickup) under the client's number for billing purposes. She actually has a billable spreadsheet and a non-billable spreadsheet so depending on the transporters yes or no response next to the client's number on their route, and whether they are billable or non-billable, ultimately I'm hoping one spreadsheet can possibly transfer data to either one of the other two spreadsheets.