Parent changes based on child info
Options
Morris R
✭✭✭✭
Hello  thank you in advance
Simple formula for MAIN TASK days to update automatically based on the longest SUBTASKS
Sub tasks take 1,4,7 days  so i want MAIN TASK to reflect 7 days.
please and thank you
Answers

Would this work?
=MAX(CHILDREN())

Yes it works for Main task (level 1) and Sub tasks (level 2) but when I make it a column formula it changes all the days to zero. (I realized the image was cut off originally as there is a row level 0 that is above)
It only worked as a cell formula not a column
thank you

 If you have a grandparent row above Main Taks and use the the same formula, it will bring the MAX of the children below it. So Site will show the max of the Main Taks, and Main Taks will show the max of their Sub Task rows.
 If you change the cell formula to a column formula it will overwrite any data in that column, therefore the numbers you had entered: 1, 4, 7... will be replaced with the formula and as those rows have no children the result will be 0. If you want this to be a column formula you can either set it up as such and then overwrite it with data (i.e. enter the sub task values), or it needs to be in a column of its own. You can find the MAX of the CHILDREN in a different column by putting the column name into the formula like this:
=MAX(CHILDREN([Data entry column]@row))
Where Data entry column is the name of the column that you type durations into.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!