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
I'm stumped as to how these two would combine.