#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# IF(Is Parent Row....

✭✭✭✭✭
edited 12/09/19

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.

Tags:

• Employee

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.

This discussion has been closed.