Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Identify matching apps with date conflicts and print out "conflict"

edited 02/05/25 in Formulas and Functions

The general idea is I have a sheet where we list each effort and the application it impacts (column "Application") as well as the dates the Code is going to be in my QA environment. I'm trying to create a formula that checks when the "Application" values match and if so compares my date range [code drop date to end prod support date] and prints "Conflict" or something where i have overlapping efforts

I tried

=IF(COUNTIFS(Application:Application, Application@row, [Code Drop Date]:[Code Drop Date], "<=" & [End Prod Support]@row, [End Prod Support]:[End Prod Support], ">=" & [Code Drop Date]@row) > 1, "Conflict", "No Conflict")

But i'm getting #unparsable, it's my first attempt building a formula in smartsheet and looking for advice

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions