Forum Discussion
Erol Kucuk
Nov 30, 2017Copper Contributor
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?
1 Reply
Sort By
Hi Erol,
=IF(I6="Complete",IF(H6>=TODAY(),"Current","Overdue"),"")