Automating Sheet Summary

Options

Hi there,

I'm extremely new to SS. I'm trying to automate our Sheet Summary on our timelines. I would like to automate the Project Health to look something like this.

RED = 7 days before due date and less than 75% complete

YELLOW = 30 days before due date and <50% complete, AND 14 days before due date and <75% complete

GREEN = 30 days before due date and >=50% complete, AND 14 days before due date and >=75% complete

GRAY = 0% complete <--- basically indicating the project hasn't Kicked off yet.

Thanks in advance for any insight you can offer.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!