Can a cell-specific formula be applied to a column?

Is it possible to apply a function to an entire column that is cell-specific? I have a Start Date, End Date, and a Duration column where I’d like the Duration column to calculate the number of networkdays between the start and end dates in the row.

Currently, it looks like this:

(yes, I know there are negative days- I'll fix this in a minute)

I had to copy and paste the formula =NETWORKDAYS([Start Date]@row, [End Date]@row) into each “Duration” cell, and am wondering if there can be a way for this formula to be applied every time a new row is made. Instead of having to copy and paste the formula to each line.


Thank you!!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!