Adding child row when columns have formulas

I have a sheet that pulls information from another sheet with Index/Match on several columns, including the primary column. I would like to be able to add child row, but when I add a row, it will not allow me to indent in to make it a child row. I believe it is because of the column formula. Any ideas of a way around this? How can I add a child row here?

Best Answer

  • Paul Newcome
    Paul Newcome Community Champion
    Answer ✓

    You will not be able to enter text into a cell being populated with a column formula. Until those rows have some kind of entry in them, they will be counted as "empty" as opposed to "blank" which means column formulas will not pull in and formatting cannot be done. You will need to find a column that does not contain a column formula and enter some kind of text there.

Answers