Need Help with Formulas (Assigned To More than 3 Projects)

I should start off by saying I am very new to Smartsheets and have little experience. I am trying to add a formula(s) to eventually use conditional formatting in Ganett view to highlight the bars red if a employee(Assigned To) is assigned to 3 or more projects with overlapping dates per state. Is this even possible??

Here is an example of the sheet I am working on


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!