IF(Is Parent Row....

Jeremy Myers

I am using the below to calculate the "days since last contact" and it works nice.  However, if the row is a parent I want to retrun blank, i.e. <>

 

=IF(OR(TODAY() - [Last Contact Date]10 > 0, [Last Contact Date]10 = TODAY()), TODAY() - [Last Contact Date]10, "Never")

 

The formula for check is a parent row is

 

=IF(COUNT(CHILDREN())>0, 1,0

 

I'm stumped as to how these two would combine.

 

 

Travis

Try adding the parent check to the beginning of the formula. Like this:

 

=IF(COUNT(CHILDREN([Primary Column]10))>0, "", IF(OR(TODAY() - [Last Contact Date]10 > 0, [Last Contact Date]10 = TODAY()), TODAY() - [Last Contact Date]10, "Never")

 

Replace [Primary Column]10 with the parent row Primary column cell (because this is the most likely column to have data in its child rows).

 

This will first check if the row is a parent, it if is the formula will show a blank result. If it is not a parent, it will continue on to the rest of the formula.