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
Need more help? 👀  Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋  Global Discussions
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
Need more help? 👀  Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋  Global Discussions

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

Glad I could help! 🙂
Need more help? 👀  Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋  Global Discussions
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.9K Get Help
 410 Global Discussions
 220 Industry Talk
 457 Announcements
 4.8K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!