IF(Is Parent Row....

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.

Find more posts tagged with

Formulas

Real Estate

Support

Comments

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.