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.
Answers
-
Hi @Shubha
I hope you're well and safe!
Are you using the Dependencies feature?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks for the reply.
I tried using the dependency feature but still got the same point error, as Parent Line always pops up with the date. however, we don't want this to be auto-filled until all the columns should be filled.
Any other solution would be highly appreciated.
Thanks
-
Do you need to use the Dependencies feature? If you do, there's no solution because you can't use formulas in those cells when using Dependencies.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
No, I just removed the dependency feature it's not working for me so instead of that I was trying a formula.
We have equipment delivery dates & they'll be different I want the parent line should capture the latest children received on the location data.
something like a formula should say that if children @row is complete then the parent line should give the latest date.
Help Article Resources
Categories
Check out the Formula Handbook template!