Trying to copy and paste formulas to a new sheet

Mark4555666

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))

Kerry St. Thomas

I suggest one of two solutions:

1. If you don't need the formula to fix to row 119, use @row instead, and then use a column formula. https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas
   
2. 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!