Convert Column to Formula Error

Hi!

The following formula calculates just fine in each cell but when I try to apply it to the entire column via the Convert to Column Formula, it's not working:

=IFERROR(WORKDAY([Date Submitted to Courseware]@row , VLOOKUP([Analysis Priority]@row , AnalysisPriorityTypeDropDown2:AnalysisPriorityTypeValue5, 2), Holidays4:Holidays46), "")

Any help would be appreciated! Thank you!

Find more posts tagged with

Accepted answers

All comments

KPH

Hi @Chelsea Duncan

Your formula references specific cells.

AnalysisPriorityTypeDropDown2:AnalysisPriorityTypeValue5

and

Holidays4:Holidays46

You cannot use absolute references in column formula.

Can you edit your data so the entire column can be included instead of those few rows? Or add an extra column to indicate which rows should be included?

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.