Auto Formatting Based on Previous Rows
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?
Comments
-
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.
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives