title: Conditionally inserting toggleable checkboxes in google sheets
body: <p>This is my first stack overflow post - “Hello World” haha</p>
  <p>I’ve put together a renewal processing list for the insurance agency I work for. Unfortunately I cannot share this sheet so I will do my best to explain the issue I’m having.</p>
  <p>The spreadsheet is a large list of policy renewal dates (Client, effective date, line of coverage, etc.). One of the columns is titled “quoting.” Which our agents will check if their in the process of quoting a line of coverage for one of our clients.</p>
  <p>Now, on a separate sheet I have a column of indexed data displaying each client that is in the process of being quoted. Next to this column I want to have several columns, each with checkboxes, allowing everyone to see what appointed carriers were quoting the indexed lines of coverage with.</p>
  <p>My problem is obviously that every time somebody checks a client on the renewal list, whatever checkboxes the other clients are associated to in the separate sheet will be off by one (the indexed values will move but the checkboxes will not).</p>
  <p>Long winded question, but in this scenario is there any way to have a toggleable row of checkboxes appear and disappear based on the presence of an indexed value?</p>
  <p>I would assume that this is maybe something that can be done in google scripts app documentation, but I’m not super familiar with it. I am happy to learn though, it seems pretty user friendly.</p>
  <p>Anyways, thank you friends!</p>