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.
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
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!