Using CONTAINS in a MAX(COLLECT) function

I have a schedule that has a task name column, a date column and a task type column. I am trying to build a formula (in another sheet) that will return the latest date based on when the task type is "APP" and the task name contains "GS" somewhere in the cell. Here is the formula I have come up with:

MAX(COLLECT({Schedule Date Column}, {Schedule Task Type Column}, "APP", {Schedule Task Name Column}, CONTAINS("GS", @cell)))

I am getting an "#INVALID COLUMN VALUE" error. Is there a reason why this isn't working? Can you not use CONTAINS inside of a collect?

Find more posts tagged with

Formulas

Scheduling

columns

Accepted answers

Jgorsich

I don't see anything obviously wrong with your formula - but invalid column value usually comes from trying to represent a date in a non date column; check the column format of the cell you are writing the formula in.

Formula error messages | Smartsheet Learning Center

All comments

Jgorsich

Formula error messages | Smartsheet Learning Center

aweber

That was the problem. Simple fix! Thank you

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.