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.


Jeffrey Ottem
Jeffrey Ottem ✭✭
edited 12/09/19 in Archived 2015 Posts

I am trying to format cells in a budget and I would like to indent the text below certain categories. For instance, in defining cabinets I have to identify the room, eg Kitchen, and then the various cabinets in the kitchen. I understand the parent/child relationship and how this works, however it doesn’t apply in this case because the entries can't be in the primary column (the only column I can see that indents) and also I don't want  them to be parent/child I just want them to be visually distinct from one another. Is there a way of formatting the text in a cell so that it isn't simply aligned to right, left or center?


  • Travis
    Travis Employee

    Hi Jeffrey, sorry for the delay in a response! 


    Do you want to format the parent row or child rows? Conditional formatting can be used to apply formatting to cells based on an aspect of that row. For example, you could use a formula to check the box of a checkbox column, if that row is a parent row, then set a formatting rule based on that checkbox. Is that what you are looking for?


    Here is the formula that can be added to a checkbox column. Make sure you adjust [Task Name]21 to reference the primary column in the row. 


    =IF(COUNT(CHILDREN([Task Name]21)) > 0, 1)

This discussion has been closed.