Help with Risk Flag and overlapping start dates

Fletcher Boll

Hello! I am having trouble with getting the risk flag to trigger if there is a start date overlapping. I have tried some countifs and if ands...keep getting #unpars :(

Please help! I need to show this to a client tomorrow!

Andrée Starå

@Fletcher Boll,

Did you get this working?

Andrée Starå

Hi Fletcher,

Can you share the formula you’re using now?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Fletcher Boll

@Andrée Starå I had been using this which I grabbed from another post and altered to fit my fields:

=IF(OR(isblank(start date@row), (ISBLANK(end date@row)),"", IF(COUNTIFS([end date]4:[end date]80, >= start date@row, [start date]4:[start date]80, <= end date@row)-1>0, 1))

Fletcher Boll

@Andrée Starå However, we no longer need the end date column so I tried this:

=COUNTIF([Start Date]4:[Start Date]80 = <1, 1)

Andrée Starå

@Fletcher Boll,

Did you get this working?