Level 1 Net Days

Jett

Hi what column formula can I use in days to sell that calculates the number of days between start date and date marked sold that calculates only on the level 1 main level. I do not need it to calculate the children.

Kerry St. Thomas

=IF(COUNT(ANCESTORS([Primary Column]@row)=0, NETDAYS([Start Date]@row,[End Date]@row),"")

Whenever I use parent/children layout, I include a Hierarchy column that includes that =COUNT(ANCESTORS(Primary)) as a column formula, so that I can use it for multiple things - references to other formulas, conditional formatting, etc. I swear, the formula is one of my best friends. :) Note that you're counting how many indent levels above the current one there are - so the top level is 0, not 1.

Good luck!