Why is an error message invalid data type generated for this formula (Please provide proper syntax)

Why is an error message invalid data type generated for this formula (Please provide proper syntax)?

=IF(AND([Start Date]@row <= TODAY(), Status@row = "Not Started", "Red"), IF(AND([End Date]@row <= TODAY(), Status@row = "Complete"), "Red", "Green"))

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Proper syntax would be:

=IF(AND([Start Date]@row <= TODAY(), Status@row = "Not Started"), "Red", IF(AND([End Date]@row <= TODAY(), Status@row = "Complete"), "Red", "Green"))

However, that particular error message leads me to believe that either one or both of the date columns is not an actual date type column or the data within one or both of those columns is not a date value.

William Kennedy

Is this a problem if I am using predecessors as both date columns have value dates and are date fields (e.g., Date/Time)?

Paul Newcome

What do you mean by "Date/Time"? Are you able to provide a screenshot of your sheet to include the column headers?

William Kennedy

The Date/Time is the column property

William Kennedy

Paul Newcome

Are you a part of the Early Adopter Program? If so, I don't believe that column type has been rolled out publicly yet. You may need to delete this thread and reach out to the EAP support.

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.