Hello. I have a workflow I'm in the process of building where I need to take data from an input file and have it write to an output template beginning on row 4. Rows 1-3 of the template should remain as is and not be impacted by the workflow. The template contains SUM formulas beginning in cell G3 and those should remain intact. I've included the workflow along with the input file and output template file. Right now I'm getting an error message "Unable to overwrite a cell that contains a formula: G3..." How can I address this?
Solved! Go to Solution.
What happens when you set the range to start in row 4
instead of row 3? The error is saying you have to avoid overwriting row 3, and that’s what you want anyways since they need to stay in tact
@Jake5
I am not quite confident that I understand your intention.
but a few point I have noticed
1. The range for output shall start from A5 not A1
2. We should not output the Header
3. Maybe Sample tool can be used to ignore first a few rows.
Thank you both! That was very helpful.