Is there a way to have each row calculate the duration?

Alicia D

Hello! I am trying to make a travel for work log where when someone enters their dates they are traveling for work, it automatically calculates it in the travel for work days column. I like how the below screen capture is set up, I would just like to find a way to automate it without having to enter in how many days they will be traveling for work. I will want it to be able to do the same thing when new rows are entered as well. I tried the duration feature, but it was only calculating the earliest start date and the latest end date for each group, rather than each row.

Charmaine

Alicia D - Hope this help still learning.

=NETWORKDAYS([start date]@row; [end date]@row)

Also converted the Travel for workdays to Formula.

Right click:

Alicia D

@Charmaine , technically that worked, but it doesn't really do will with my formatting. Is there a way to apply this formula just to the child rows?

Alicia D

@Charmaine , it says this is an incorrect formula, but could I do something like this? =IF(COUNT(CHILDREN())(NETWORKDAYS([Start Date]@row, [End Date]@row)

Andrée Starå

Hi @Alicia D

I hope you're well and safe!

Try something like this.

=IFERROR(IF(COUNT(CHILDREN([Primary Column]@row)) > 0, "", 
NETWORKDAYS([Start Date]@row, [End Date]@row)), "")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Alicia D

When I enter that formula, this is what is says:

Alicia D

@Andrée Starå , forgot to tag you in the above!

Alicia D

@Andrée Starå , could this be because my primary row is actually the employee names?

Alicia D

@Andrée Starå , sorry for all of the messages! I think I figure it out, thank you for the help. I just wonder if there is a way to count the sum in the parent rows of the children rows below? I tried to add a formula to the parent rows but saw that I can't have 2 formulas if one is a column formula. Is there a workaround to this?