Revisions to List Validations

added 2 characters in body; edited tags

Source Link

edited Mar 4, 2022 at 4:06

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]=””[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.

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.

added 3 characters in body

Source Link

edited Mar 4, 2022 at 3:31

I am terrible at writing formulas. II 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)

=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...

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.

edited tags

Link

edited Mar 4, 2022 at 1:18

Source Link

asked Mar 3, 2022 at 21:10

Loading

Return to Question