I am trying to generate some rows using Smart Markers, but I want to preserve the formulas that are in the existing cells. I find the &=&= syntax to be difficult to write and I want to be able to give the template to business owners to make changes. Is there a reason we can’t do something like this? As long as the formula is relative, then when using the smart marker collection to copy the row and styling it should also be possible to copy the relative formula.
preserve formula example.JPG (16.2 KB)