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 indexmatch 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

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

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

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

Glad I could help! 🙂
Help Article Resources
Categories
Check out the Formula Handbook template!