I was wondering if someone could help me with an issue I'm having in SharePoint. I made a library and one of the columns has a Yes/No option. The following column is based on that response. If the answer is Yes I have a drop down with 3 different options, however if the answer is No there is only one option it could be. Is it possible to have the column auto-populate is someone selects the No option?

  • I think the best way would be to add an If Then formula, I'm trying to say If [Systems Action Required] column is No, then [Systems Status] column should be N/A, if not then leave it blank. I tried this: =IF([Systems Action Required]="Yes",[Systems Status]="N/A",[Systems Status]="") but it didn't work
    – jason
    Jul 8, 2015 at 16:17
  • What version of SharePoint are you using? Jul 8, 2015 at 16:31
  • I'm using SharePoint 2010
    – jason
    Jul 8, 2015 at 17:28

1 Answer 1


I only know how to do this using InfoPath - create a rule pertaining to the yes/no column based on the value...populate the drop down according to the rule. Hope this helps...

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.