How to Have Formula Continue to Next cell When Dragged Down.

I am creating a delivery & install sheet. On the delivery sheet I have a column that is a date property, on the install sheet the correlating column is also a date property. I am using the workday formula, "(=WORKDAY({Exterior Delivery}, 1, {Holidays Range 2})". The problem is the function won't apply to the other cells when dragged down. It would be extremely tedious if we were to have to type the formula for every single install cell. I tried referencing the entire delivery column, but it just pops up as invalid data type.

Find more posts tagged with

Formulas

Accepted answers

All comments

Mark.poole

you should be able to right click on the cell and choose convert to column formula

Olivia Keystone

https://community.smartsheet.com/discussion/comment/441418#Comment_441418

When I do that it only references the single cell from the formula. So the whole column is referencing one date, not converting to each individual date.

Mark.poole

https://community.smartsheet.com/discussion/comment/442462#Comment_442462

https://help.smartsheet.com/function/workday

The issue is in how your trying to use the workday function.

the first portion of the work day function can not be a range. so if your using a reference sheet to pull dates. you would want the do the function there to create a column to reference.

how ever WORKDAY always counts sat and sun as non working days.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.