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

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.