How to apply conditional formatting on cross sheet reference (dates)?

Hello,

Can anyone help me with figuring out how to apply conditional formatting to cross sheet references (dates)? I am realizing that even if the column is set up as a date, Smartsheet is not reading the cross sheet reference (these are vlookup and index-match formulas) as a date, and I cannot format. I tried creating a second column, using a join formula and such, but cannot figure this one out. Any help is VERY MUCH appreciated!

Thank you.

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @GLopSmith

It sounds like the column you're placing the formula into is a Date type of column, but is the column you're pulling data from in the source sheet also set to Date?

It sounds like the formula may be translating your date values into text values, even though they're showing up in a Date column.

Could you test this by using this formula, looking at the formula date:

=IF(ISDATE([Formula Column]@row), "Seen as Date", "Seen as Text")

Screen Shot 2022-04-28 at 1.27.23 PM.png

If they're showing up as "Seen as Text", can you post the formula you're using, along with information about the Source sheet data/columns?

Thanks!

Genevieve

All comments

Genevieve P.

Hi @GLopSmith

It sounds like the column you're placing the formula into is a Date type of column, but is the column you're pulling data from in the source sheet also set to Date?

It sounds like the formula may be translating your date values into text values, even though they're showing up in a Date column.

Could you test this by using this formula, looking at the formula date:

=IF(ISDATE([Formula Column]@row), "Seen as Date", "Seen as Text")

If they're showing up as "Seen as Text", can you post the formula you're using, along with information about the Source sheet data/columns?

Thanks!

Genevieve

GLopSmith

Thank you so much @Genevieve P. - that actually helped me solve my problem! You are a lifesaver!

Genevieve P.

Glad I could help! 🙂

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.