Auto Formatting Based on Previous Rows

BarneeL

I have a smartsheet that is populated by a form, I set up a row at the top of the document that I hoped would set the formatting for the rest for the rest of the document.

Based on my experience doing with this in other smartsheets, this seems to work. But in this case the formatting doesn't seem to be applying to new rows in the smartsheet. Does anyone know how to make it do this?

BarneeL

I figured out out. I needed to highlight the entire column I want to format, format it the colour I want it to be, and then reformat my header rows back to how they were before.

Andrée Starå

Hi Barnee,

This will probably be easier for you.

Please see the attached link/screenshot for more information.

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

Conditions That Trigger Automatic Formatting

You’ll see automatic formatting occur when you type in a newly inserted or blank row that is:

• Directly between two others that have the same formatting applied.

• At the very top of the sheet if it's above two others that have the same formatting applied. (This includes rows inserted from a form.)
• Above or below a single row that is between blank rows and has formatting.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting