Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Setting a default format with Parent/Child Rows

11/28/17 Edited 12/09/19

Hello,

Is it supported to set a default format for parent/child rows? For example, when a row becomes a parent, automatically

  • set text to bold
  • set text size == 16
  • set the row background color to gray and
  • set the text to white.

Thank you,

Justin

Comments

  • J. Craig WilliamsJ. Craig Williams Top Contributor

    1. Add a Checkbox column with this formula

    =IF(COUNT(CHILDREN([Primary Column]23))>0,1,0)

    for your Primary Column (change to your column name) and row 23 (then copy to the rest of the column)

    This will be checked when the row has children.

    2. Then set up Conditional Formatting for when the Checkbox is checked.

    Craig

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    edited 11/29/17

    Craig beat me to it! ;)

    Hi Justin,

    Yes this is possible with with some conditional formatting and som other tricks.

    I'll get back later and write how it's accomplished.

    Best,

    Andrée

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Thank you Craig!

  • Thank you.

This discussion has been closed.