Formula for Status
I would like to auto create a status based on an end date, completed date, cancelled checkbox or on hold checkbox. If end date is in the future an neither checkbox is selected then "Open". If the end date is in the past then "Overdue". If complete date has been entered then "Complete". If cancelled checked then "Cancelled". If On Hold checked then "On Hold". This is what I have so far with no luck.
=IF(ISDATE([Complete Date]@row), "Complete", IF([due due]@row > today (), "Complete", IF([email protected] = 1, "Cancelled", IF([On Hold]@row = 1, "On Hold", "Open"))))