Error when refrencing a date column in formula

I am attempting to change the Fabric status column based off the dates in Fabric A,B,and C received date columns. I want to return a value of Received in the helper column if there is a date in Fabric A received date, unless 2nd fabric required is checked, then Return the value of Received when there is a date in both A and B columns, and then again if 3rd fabric required is checked it needs to have dates in all 3 columns to return 'Received' . I will then do an automation to update the dropdown in Fabric Status

However i keep getting errors, so i have done the most basic formula and i am getting errors, can someone please advise me what i am doing wrong.

Much appreciated

Find more posts tagged with

Formulas

dates

Accepted answers

All comments

Amit Wadhwani

Hi @Jimbobwild

Seems like you select Text/Number as column type for helper column. You should change its type to Date.

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.