I am using this formula to show status of an item of it is past it’s target date, on target or completed before it’s target date. I also want the column to be “blank” if one of the dates was missing (Legals Completed). See formula below:
If you’re considering adding further complexity to this formula, you might want to use CONCATENATE, as this command will prevent you from nesting statements too deep. You can easily combine mutually exclusive statements such as these in that way, returning a blank value when the statements are false.