Conditional formatting not working with certain portion of a formula
Hello all. I have a date column that is populated via a formula, referencing other cells within the same sheet (both date and drop downs). Before I changed this column to populate via a formula, I had simple conditional formatting based on if date was in the past (red) or in the future (green). Since I added the formula, now some dates in the future are RED.
Those that are now incorrectly red are specifically those with Agreement Type "MSA" and have the Expiration Date column as 12/31/21. This date is set with Date(21,12, 31) in my formula, so my understanding is that this would create a date type, not a text.
Below are some screenshots of my CF, sheet and formula. Ideas?
Best Answer
-
The Date function requires the year to be set in YYYY format, so inputting YY is looking for the year 21, not the year 2021.
Try adjusting it to
DATE(2021,12, 31)
Cheers!
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Answers
-
The Date function requires the year to be set in YYYY format, so inputting YY is looking for the year 21, not the year 2021.
Try adjusting it to
DATE(2021,12, 31)
Cheers!
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
That worked, thanks Genevieve!
-
No problem! 🙂
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 142 Industry Talk
- 473 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
