Show Minimum date of children, if blank put a dash

tlawrence

I'm having an issue with a sheet I am working on.

I want a parent row to show the minimum date of the child rows, "=MIN(CHILDREN())" which works fine. However if there are no dates yet, I want the cell to display a dash "-" and for the life of me I can't get this work. I have tried using ISBLANK but I don't think I am doing it correctly because I keep getting an INCORRECT ARGUMENT SET error.

The cell is "Started2"

The formula I am using is: =MIN(CHILDREN(), IF(ISBLANK(), "-"))

I have also tried: =MIN(CHILDREN(), IF(ISBLANK(Started2), "-")) but I get a circular reference error.

It's not a huge deal but I just think it makes the sheet look a lot cleaner.

Paul Newcome

Try something like this...

 

=IF(COUNTIFS(CHILDREN(), ISDATE(@cell)) > 0, MIN(CHILDREN()), "-")

.

Basically it counts how many of the children cells are dates. If that number is greater than zero (meaning there is at least one date), then it will pull the lowest date, but if that count is a zero (meaning there are no dates), it will return the desired dash.