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....
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.
Comments
-
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.
