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

meghan.berger

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!!

DKazatsky2

Hi @meghan.berger,

Yes, right-click on the cell with the formula and choose "Convert to Column Formula".

Hope this helps,

Dave

meghan.berger

Hi @DKazatsky2

Thank you for responding- When I go to follow these steps, the "convert to column formula" option is greyed-out, so I cannot select it. Any thoughts?

juliesilverio

Are you an admin on the sheet? If not you won't have the capability but a sheet admin can do this for you.