Auto-formatting on New Rows
I'm trying to build a collaborative sheet for my team, but every time someone adds a new row, the formatting from the (January, February, etc.) parent rows applies to the new row. Is there a way to turn this auto formatting off so all new rows entered into the sheet are standard white rows with 10 pt black text?
Answers
-
@monica16145 You could create a helper column with a =Count(Ancestors()) formula as a column formula, then use Conditional Formatting to format rows based on the number in the result.
With this formula, a top level row would =0 because it has no ancestors, the first child would =1, the child below that =2, and so on.
-
Neat! This worked pretty well but for some reason the italics, size 12 font, and bold formats are still carrying over. (everything except the blue background color). I set up the conditional formatting like this:
If "Helper Column" is not 0 then apply this format to entire row.
Any idea why its doing this? Thanks
-
Hi @monica16145
I hope you're well and safe!
Ensure you're changing all the formatting settings set by other rules or manually in the sheet.
Make sense?
Did that work/help?
I hope that helps!
Have a fantastic week & Happy Holidays!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
-
Hi Andrée, I do not have any other formats set in the sheet that would compete with this one. What do you mean by manually changing?
-
With manual, I mean the ones that you change the format manually, and that format will show if you don't select something instead of it in the rule.
Make sense?
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
-
@monica16145 Also note that formatting rules apply in order from top to bottom. So 1 rule could cancel out another. You may need to reorder your rules.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!