Checkmark Parent if any Children Due Date is in the next 7 Days

Answers

Maricarmen Vargas ✭✭✭✭

01/16/20

@Paul Newcome thank you!!

0 · Share on Facebook Share on Twitter
Paul Newcome Community Champion

01/16/20

Happy to help! 👍️

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Created Date Column Background behaviour
Hi Smart Sheeters! I have a created date column in my sheet which updates whenever I open up the sheet. I have a column that uses it (See formula). And it also updates whenever I open it up. This doesn't feel like normal behaviour. Can I change my formula to take the time from a created date column as a string/text value…
Collect an column entry when data is entered by a form
Hi, I'm still tearing my hair out over this issue, and I'm hoping someone can help me. In our set up that is run through control centre, we have specific information that is entered onto a sheet via a form. I need to link the information that is entered into that form back to the metadata for each project. The issue I'm…
Schedule health formula to display blank symbol
Hello! I am curious how to edit the below formula, to show blank instead of green/yellow/red symbol if status/end date is blank: =IFERROR(IF(Status@row = "Complete", "Green", IF(Status@row = "N/A", "Green", IF([End Date]@row = TODAY(), "Yellow", IF([End Date]@row < TODAY(), "Red", "Green")))), " ")