Help with a Harvey Ball formula
Hello everyone who's smarter than me: I need a formula to result in the following:
Field empty if no start date listed
Green ball if complete, regardless of start date
Yellow ball if not complete and start date is within the next week
Red ball if not complete and start date is in the past
Gray ball if start date is more than one week away.
Here are my column names:
Help Article Resources
Check out the Formula Handbook template!