Formula skipping rows
Hi all,
I'm trying to use the below function to automatically change the color of Harvey balls to red, yellow, or green based on the length of time till a task's due date.
=IF([Due Date]@row >= TODAY(+61), "Green", IF([Due Date]@row >= TODAY(=31), "Yellow", "Red"))
However, for some reason some rows show "#invalid operation" rather than a colored ball.
I've reached out to support but haven't received any direction on how to adjust my formula. So any help or direction would be greatly appreciated.
Thank you!
Best Answers
-
Try this...
=IF([Due Date]@row <> "", IF([Due Date]@row >= TODAY(61), "Green", IF([Due Date]@row >= TODAY(31), "Yellow", "Red")))
-
You would use something like this...
=IF(Standing@row = "Complete", "Blue", IF([Due Date]@row <> "", IF([Due Date]@row >= TODAY(61), "Green", IF([Due Date]@row >= TODAY(31), "Yellow", "Red"))))
Answers
-
Try this...
=IF([Due Date]@row <> "", IF([Due Date]@row >= TODAY(61), "Green", IF([Due Date]@row >= TODAY(31), "Yellow", "Red")))
-
Thank you, Paul! You're a rock-star. :)
-
@Paul Newcome , what would I add if I wanted anything marked as "complete" in a column labeled "standing" to show as blue?
I've tried playing around with it myself, but no luck.
-
You would use something like this...
=IF(Standing@row = "Complete", "Blue", IF([Due Date]@row <> "", IF([Due Date]@row >= TODAY(61), "Green", IF([Due Date]@row >= TODAY(31), "Yellow", "Red"))))
-
Thank you so much, Paul! Greatly appreciate your help. :)
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!