Im trying to create a formula that will show the days over due or highlight over due if a date is not filled in....

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Im trying to create a formula that will show the days over due if a date is not filled in. For my formula, I have a Date of Death field and a Date Petition was Filed. If it has been 30 days since the date of death and no date is put into the date petition is field, I want the task to show as overdue. Any Thoughts?
Photo of Angela

Angela

  • 270 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of John Thomas

John Thomas

  • 1,062 Points 1k badge 2x thumb
Insert the below formula to the formula text field 

If(IsNull([Date of Petition]) and ToDays(Today() - [Date  of Death]) >=30 , "Overdue"  )

I hope this will solve your issue!!!
Photo of Angela

Angela

  • 270 Points 250 badge 2x thumb
Perfect.  Thank you John.  If I wanted the text Overdue to be red and bold, where would I add the HTML into the formula?
Photo of John Thomas

John Thomas

  • 1,062 Points 1k badge 2x thumb
If(IsNull([Date of Petition]) and ToDays(Today() - [Date  of Death]) >=30 ,  "<span style=\"color:#ff0707; font-weight:bold\">"&"OverDue"&"</span>" )

Ensure that you made the html tags as allowed


Is it fine? :) 
(Edited)
Photo of Angela

Angela

  • 270 Points 250 badge 2x thumb
Thank you!  Works Perfect!