Parent/Child and having to reformat

Melissa Lee

I have a Form that has in the settings for all rows to start at the top. Then columns are color coded. It was working beautifully. Then, I introduced Parent/Child formatting to show "In Progress" and then "Approved". But now my Parent Row gets in the way of new submittals from the form. It color codes to the Parent Row vs the rest. HELP!

BullandKhmer

Hi there,

Have you color coded everything manually? You could color code via conditional formatting. Without thinking about it too deeply, something like IF job title <> "in process" or 'Approved" then colorcode the row like this.