Skip to main content
Question

If Statement help / Checkbox override

  • February 27, 2019
  • 0 replies
  • 72 views

I currently have the following If Statment in my field called [terminal - internal]

long story short there comes a time where I need to override this information with the info from another field called [alternative terminal]

I've created a checkbox and I wanted to see if I can modify this if statement so that when the checkbox is checked the value in [terminal-internal] becomes the value that in [alternative terminal]

I hope this makes sense - pretty much override the the [terminal-internal] with the [alternative terminal]

If(
[Port of Loading]="Vancouver", [Voyage Dates - Terminal2],
[Port of Loading]="Seattle", [Voyage Dates - Terminal 3],
[Port of Loading]="Tacoma", [Voyage Dates - Terminal 3],
)
This topic has been closed for replies.

  • Registered
  • February 27, 2019
I would do:

If([new checkbox field]=true,[alternative terminal],
If(
[Port of Loading]="Vancouver", [Voyage Dates - Terminal2],
If([Port of Loading]="Seattle", [Voyage Dates - Terminal 3],
If([Port of Loading]="Tacoma", [Voyage Dates - Terminal 3],
))))

  • Author
  • Registered
  • February 28, 2019
thanks - i'll give this a go