Share via

Developer Conditional Statement - Content Controls - autofill based on two drop down lists

Anonymous
2022-10-11T18:01:52+00:00

I am attempting to autofill a document based on the selection in two different drop down lists. I have bookmarked the drop down lists and can successfully autofill based on one of them but can not figure out how to have the conditional statement consider the second drop down as well, before auto filling.

This is what I have so far;

{ IF {REF Bookmark1}="Selection 1" "Pursuant to section 123 ITOA"{ IF {REF Bookmark1}="Selection 2" "Pursuant to section 456 ITOA" }}

I would like to add in the consideration of Bookmark 2. Basically; IF Bookmark1=Selection 1 AND Bookmark2=Selection 1 then autofill with "abc 123"

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Doug Robbins - MVP - Office Apps and Services 323.1K Reputation points MVP Volunteer Moderator
2022-10-12T12:15:54+00:00

Just delete

"Other result for bookmark1"

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

Answer accepted by question author

Doug Robbins - MVP - Office Apps and Services 323.1K Reputation points MVP Volunteer Moderator
2022-10-11T20:02:27+00:00

Use

{ IF { REF Bookmark1 } = "Selection 1" { IF { REF Bookmark2 } = "Selection 1" "abc 123" "Other result for Bookmark2 } "Other result for Bookmark1" }

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Anonymous
    2022-10-12T17:24:21+00:00

    AMAZING! Thanks so much!

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2022-10-12T12:02:32+00:00

    Thanks so much for your quick reply.

    Unfortunately this still won't work for me. Once written the result being produced is "Other result for bookmark1" and it is appearing after the entry of the first drop down (bookmark1).

    Ideally if bookmark1 and bookmark2 do not equal what is identified in the conditional statement I would like the fillable field to remain blank.

    Was this answer helpful?

    0 comments No comments