Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Checkmark Parent if any Children Due Date is in the next 7 Days
Stuck testing out formulas to add a Column [Children Due Soon] that checkmarks if a parent row [Task Name] has any children task is due [Due] in the next 7 days.
I've been trying to edit the famous RGB formula for this, but still not very familiar with formulas.