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

Options

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.

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    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

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    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
    Options

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

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Glad I could help! 🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!