Status Ball formula question


I'd like to create a formula to automatically change the color of the status ball but I've never created an IF statement and could use some help please.

If equal to or less than Meeting Start date, then yellow

If equal to or between Meeting Start date and meeting end date, then green

If equal to or after Finalize Budget, then red


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!