Forum Discussion

Erol Kucuk's avatar
Erol Kucuk
Copper Contributor
Nov 30, 2017

Current, Overdue or Complete forumla

Hi

 

I have written the formula below to track overdue questions. I am having difficulty combining

=IF(I6>=1,"Complete") with the formula below.

My table will be tracking when a question is sent, the date a response is required and whether the response is current, overdue or complete.

 

=IF(H6>=TODAY(),"Current","Overdue")

 

Can anyone assist?

 

Resources