Parent Based Formula Needed

Hi Team,

So I have a question, Parent Line always pops up with the date, however, we don't want this to be auto-filled unless all the children should be filled & the date should be the latest one.

What formula should be the best in this situation?

Also, If all the children @row have N/A's and one is still blank then the parent line shouldn't take N/A instead wait for that one particular column to be filled.

@Paul Newcome Appreciate your help.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!