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(,).
| improve this answer | |
  • Try this and let me know it works or not. – Ganesh Sanap Feb 22 '19 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. – Jason Hough Feb 22 '19 at 14:34
  • I have added a picture where can see on the edit screen its one value and on the list its another. – Jason Hough Feb 22 '19 at 14:38
  • any ideas anyone ? – Jason Hough Feb 22 '19 at 14:52
  • even with the simplest validation it does not work - such as : =OR(TAtestColumnChoose="Copy",TAtestColumnChoose="No-Copy") – Jason Hough Feb 22 '19 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.