Flag overlapping projects based on RYG ball

edited 12/09/19 in Formulas and Functions

I've looked and am unsure if smartsheet is even capable of this, but can I turn on a flag based on if a new rows start date falls in between the start date and completion date of any other row? I'm also trying to have it triggered ONLY when the complexity (RYG ball) is red.

Am I far off with this formula:

=IF(AND([Start Date]@row >= [Start Date]:[Start Date], [Start Date]@row <= [Completion Date]:[Completion Date]), IF(AND([Project Complexity]:[Project Complexity], "Red", 1)))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!