Columns
"Risk"
"Start Date"
"Part Status"
I want "Risk" to FLAG, if "start date" is TODAY or > and "Part Status" is NOT "shipped" or "in progress"
I have the formula below for if start date is today or >
=IF(ISDATE([Start Date]4), IF(AND(TODAY() > [Start Date]4), 1))
How can I combine AND if "Part Status" is NOT "shipped" or "in progress" into this formula?