Is there a way to have each row calculate the duration?
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.
Answers

Alicia D  Hope this help still learning.
=NETWORKDAYS([start date]@row; [end date]@row)
Also converted the Travel for workdays to Formula.
Right click:

@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?

@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)

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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

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

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

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

@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?
Help Article Resources
Categories
Check out the Formula Handbook template!