Trying to copy and paste formulas to a new sheet
I understand that adding a single quote, '
In front of a formula row allows you so see, copy and paste that into a new sheet.
I am trying to add a single quote in front of 102 rows with formulas but the join function is only allowing me to join the two cells. My thought was to add a text column with only the single quote and then concatenate but that does not work.
Is there a way to concatenate the single quote to the front of a formula?
Resulting cell would be:
'=COUNTIFS(CHILDREN($[Date In]$119), >=DATE(2024, 1, 1), CHILDREN($[Date In]$119), <=DATE(2024, 1, 30))
Answers

I suggest one of two solutions:
 If you don't need the formula to fix to row 119, use @row instead, and then use a column formula.
 If a column formula won't work for your use case and/or you do need to fix to row 119, don't try to copy the entire column of formulas…just copy one cell. Then when the formula is in the destination sheet, drag the formula to fill the column to the other 101 cells.
Good luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response  "Insightful"or "Awesome" reactions are much appreciated. Thanks!
 If you don't need the formula to fix to row 119, use @row instead, and then use a column formula.
Help Article Resources
Categories
Check out the Formula Handbook template!