I have a sheet in each project created via blueprint and I need to be able to add a row to it. I'm looking for advice on how best to do this.
For context, it's a sheet with a contact and an assignment for each contact. It can't be a single master sheet because the assignment can be different between projects. For example, Dave might be a designer on most jobs, but an assistant designer on just a few.
This solution works until I need to add a new contact. If Jeff joins the company, he needs to be added to this sheet across all projects with 2 pieces of information, his name as a contact [yes, it does have to be a Contact format] and a default assignment.
The only way to add a row to a sheet via control center is via an Add Profile Data update. I can do this on the sheet in question by creating what is effectively a faux summary row. Unfortunately, I can't have this global update add both pieces of information. Additionally, I can't add this data in the correct column for the assignment, or can I add it as a properly formatted contact value for the contact. Running it via the intake sheet does let me assign the column, but I still can't add both at once.
I've considered using a follow up Find / Replace update to populate the fields that can't be added correctly via add profile data. Unfortunately, this update type seems to be incapable of adding info to a cell that is blank, only replacing the value in a populated cell. I've also considered using some kind of convoluted mess of automations that might let me update the sheet to match the template, then port all the old assignments back in, but there isn't an option for updating sheets, just reports and dashboards.
My current plan is to run an add profile data global update to create the row. this would trigger an automation on the sheet to populate placeholder values in the two columns i need to update. I would then need to run a second Find / Replace global update to switch those two placeholder values with the correct contact and default assignment on just the one row.
Does anyone know of a better way to go about this? This started out as a very simple update and has since spiraled into hours of research & testing, and I feel like I'm missing something obvious, but I'm not finding anything.
Thank You
