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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!