getting date from another sheet gives #INVALID COLUMN TYPE error

Sheet 2

When we click start_date reference sheet then opens reference window as below!

Reference Sheet (Sheet 2)

Sheet 1: Created date id of Date type

Please Assist!

I only want to get the create date into start date.

Date is present in a sheet 1

I'm referencing it in sheet 2 but gives an error

It works if the created date is of text type column

Find more posts tagged with

Accepted answers

All comments

Dakota Haeffner

The column that you are putting the formula in, change it to a date column and see if it spits out the date then.

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.