Parent Based Formula Needed
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
Check out the Formula Handbook template!