View Single Post
 
Old 09-27-2017, 04:28 PM
emckillen emckillen is offline Mac OS X Office 2011 for Mac
Novice
 
Join Date: Sep 2017
Posts: 5
emckillen is on a distinguished road
Default

Brilliant, thanks!

Last question:

How to I create multiple IF statements in one field?

I want a field to display different text depending on the selection of a drop down menu, so I that means I need something like:

{{IF "Dropdown1" = "Montreal", "Montreal Address"}{IF "Dropdown1" = "Laval", "Laval Address"}}

But that doesn't seem to work. It doesn't update when I go "update field".
Reply With Quote