Overallocation flag in sheets

Gordon
Gordon ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Is there a formula or method to identify if a resource allocation flag is triggered for a given row?  i.e. have another column in the same sheet that is checked/unchecked or true/false if the "red man" flag is on for a given row? 

I'm trying to figure out if there's a way to summarize all of the rows in our project sheets with resource conflicts so I was thinking if I could add a true/false or checkbox column that could be tied to the red man flag, then I can create a report that would only show rows with the box checked/true.

Hopefully this question makes sense.  Basically, I want a report that would show me all the "red" resource conflicts in the resource management screen.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!