MIN(CHILDREN()) Not Functioning As Expected

Options
Sandra Guzman
Sandra Guzman ✭✭✭✭✭✭

Hello Smartsheet Community!


I am using the MIN(CHILDREN()) and MAX(CHILDREN()) formulas to determine dates that roll up to my parent row. In testing out the functionality it appears that the MIN formula is not pulling through the oldest date as I would expect it to.


Some background: I am currently using 6 date columns. The predecessors/duration is being used for my Planned Start/End date columns. The columns that I am trying to apply this to are the Actual Start/End dates columns that require the date to be manually entered. Both of the columns properties are set to "date."


In the below snapshot you can see that my oldest date in the Actual Start Date column should be 07/28/20 but that is not what is displayed in the orange cell.


I have tried deleting and re-entering the formula. It appears that My MAX formula is working just fine (knock on wood).


So I am hoping to learn if any of you have any idea as to why this might be happening and hopefully you can also provide me with a possible troubleshooting suggestion.


Thanks so much!

Best Answer

Answers