1

I've created 3 columns:

  1. Choice:
    • Banana
    • Apple
    • Orange

2.Start date

3.End date

If you select "banana", then he/she must input value for "start date" and "end date".

I tried to input the formula below at start date but it doesn't work.

=if([Choice]="Banana",[Start date]=today(),true, false)

Could anyone out there help me?

2 Answers 2

1

Try below formula:

=IF([Choice]="Banana",IF(OR(ISBLANK([Start date]),ISBLANK(End date)),false,true),true)

This satisfy the condition: If [Choice] is equal to "Banana" then user cannot leave Start date or End date columns blank.

Note:

  1. Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).

official documentations:

  1. Calculated Field Formulas.
  2. IF function.
1
  • You need to add this formula in Validation Settings under List Settings and not column settings. Apr 1, 2020 at 7:50
0

You could use formula as Ganesh said via List settings->Validation settings->type the formula as below:

=IF([Choice]="Banana",IF(OR(ISBLANK([Start date]),ISBLANK(End date)),false,true),true)

Since the single column validate cannot refer to other column value, we cannot add the formula under certain column.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.