Formula to check KPI Met box if Current Review Complete is less than Complete Update Due By...

Heather Mize

Hello! I need a formula to check KPI Met box if "Current Review Complete" is less than "Complete Update Due By", however if the Current Review Complete cell is blank, do not check the KPI Met box.

Thanks so much for your help!

Andrée Starå

Hi @Heather Mize

I hope you're well and safe!

Try something like this.

=
IF([Current Review Complete]@row <> "", 
IF([Current Review Complete]@row < [Complete Update Due By]@row, 1))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Heather Mize

I hope you're well and safe!

Try something like this.

=
IF([Current Review Complete]@row <> "", 
IF([Current Review Complete]@row < [Complete Update Due By]@row, 1))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Heather Mize

Yes! Thank you so much!!!

Have a great week!

Heather

Andrée Starå

@Heather Mize

Excellent!

Happy to help!