#INVALID COLUMN VALUE Error, when using a formula with a column set as Date

Hi,

I'm encountering difficulties changing the Dates of certain cells using a Formula. In this instance, I write

=WORKDAY([Date used in Formula]@row + 10

while referencing a Column set as Date type, and it still gives me the Invalid Column Value error. I'm really confused can Someone help me.

Additional infomartion: There is a conditional formating set on the entire sheet if that somehow could cause an error.

Thanks

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

The formula also needs to go into a date type column.

=WORKDAY([Date used in Formula]@row, 10)

SmartSheet User1

https://community.smartsheet.com/discussion/comment/475728#Comment_475728

Both columns are already Data type columns, that's why I'm so confused

Elska19

Is the column the formula is in set as Date Type? If not that could cause an issue. You would either need to have the column the formula is in set as Date type or update the formula to be

=WORKDAY([Date used in Formula]@row, 10)+""

The +"" will allow it to show as a date in a text/number column.

Paul Newcome

How is the original date type column populated? Are you able to show provide a screenshot of the formula open in a cell as if you are about to edit it?

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.