Current Milestone task name for the current row

Current Milestone task name for the current row


Relatively new to smartsheet and getting to grips with sum of the hierarchy functions

I want a formula that returns the task name for the milestone of any given task.

or the task name of the last child

any help very much apreciated



  • Hi Andy,

    There may be a better way of achieving this but I have one idea you can try. Are you using Dependencies on your sheet? Do you have Project Settings enabled? If you do, and your main Parent Task automatically has the last end date populated, then this formula may work for you:

    =INDEX(CHILDREN([Task Name]:[Task Name]), MATCH([End Date]$1, CHILDREN([End Date]:[End Date])))

    This looks through the Task Name column and returns the task that matches the End date of the Parent row with the End Date of the last task. I've locked in the top parent end date with the $ sign: [End Date]$1

    You will need to update this number to each parent row's number. Does that make sense?

    Let me know if this will work for you! If not, it would be helpful to see a screen capture of your sheet (but please block out any sensitive data).



Sign In or Register to comment.