I am terrible at writing formulas. I need a list validation formula to make all fields mandatory unless the status is in DRAFT.
=NOT([Stage]=0 DRAFT,IF([Function]=””,FALSE,TRUE),TRUE)
But there are about 20 more fields to add to this statement...
I am terrible at writing formulas. I need a list validation formula to make all fields mandatory unless the status is in DRAFT.
=NOT([Stage]=0 DRAFT,IF([Function]=””,FALSE,TRUE),TRUE)
But there are about 20 more fields to add to this statement...