Hi there,
I currently have this formula (below) for my checkboxes that states if the end date is less than 30 days away and the Status of a project is "In Progress" the checkbox is checked off. Currently, if the End Date field is left blank and the Status is "In Progress" the checkbox is marked off. I want to make it so if the End Date is blank there is no check mark. What is the best way to go about this?
Formula: =IF(AND([End Date]@row <= TODAY(30), Status@row = "In Progress"), 1, 0)
Thanks!
Mahshad