How I stop the new row from getting the format of the header line ?

Ziad Albarazi

Hi

When I use copy/move row to other sheet , the source table become free , so when I enter a value in a new row , it get the format of the header which I don't want

Is there any way to stop the new row from getting the header format ?

Thanks

Andrée Starå

Hi Ziad,

Yes, but you'll have to make sure that the below conditions aren't met.

The short version! It will be auto-filled with the same format if at least two rows before or after is the same format.

More info:

If the formula structure is the same above/below the Formula Autofill will add the formula(s) automatically.

Conditions That Trigger Formula Autofill

You’ll see formulas populate automatically when you type in a newly inserted or blank row that is:

• Directly between two others that contain the same formula in adjacent cells.
• At the topmost of the sheet if it’s above two rows that have the same formula in adjacent cells. (This includes rows inserted from a form.)
• At the bottommost of the sheet if it’s below two rows that have the same formula in adjacent cells. (This includes rows inserted from a form.)
• Above or below a single row that is between blank rows and has formulas.

https://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!