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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!