1

enter image description hereI have a requirement, if a user chooses 'Copy' from a drop down an additional field needs content, and if the user choose 'No-Copy' then the additional field CAN be blank.

Here is my script and when it runs it works fine, but if 'No-copy' is selected afterwards the change does not happen in the list. So I believe its my script that is at fault.

=IF(TAtestColumnChoose="Copy",IF(ISBLANK(Description),FALSE,TRUE),FALSE)

any help would be great.

2

You need to set the formula value to TRUE in case user selects the "No-Copy". So, try using below formula:

=IF([TAtestColumnChoose]="Copy",IF(ISBLANK([Description]),FALSE,TRUE),TRUE)

Note:

  1. Sometimes comma(,) does not work in formula (I am not sure but it is based on something language on your site). So in that case use semicolon(;) instead of comma(,).
  • Try this and let me know it works or not. – Ganesh Sanap Feb 22 at 14:20
  • it works once as No-Copy, then as Copy, and then when I change It back again the column does not change on the list. – user3437628 Feb 22 at 14:34
  • I have added a picture where can see on the edit screen its one value and on the list its another. – user3437628 Feb 22 at 14:38
  • any ideas anyone ? – user3437628 Feb 22 at 14:52
  • even with the simplest validation it does not work - such as : =OR(TAtestColumnChoose="Copy",TAtestColumnChoose="No-Copy") – user3437628 Feb 22 at 15:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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