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.


Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!