cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
mcswegin
Nintex Newbie

Nested If statement

I am trying to populate a form with respective territories, but only if the territory line has a value (otherwise I would like to leave it off of the form (not just blank)).

The following populates the territory every time:

{IF "<<Rocky_Mountain_Division>> = "Rocky Mountain" "Rocky Mountain" ""}

What I would like to do: If there is no Rocky Mountain Division, then delete that row on the table. Was thinking of some kind of nested statement, not sure where to go or the proper syntax to do this.

My thought was something along these lines, but it doesn't work.

{IF "<<Rocky_Mountain_Division>>" = "" "" (IF "<<Rocky_Mountain_Division>>" = "Rocky Mountain" "Rocky Mountain" "")} 

Labels: (2)
Tags (1)
0 Kudos
Reply
5 Replies
pwarrak
Nintex Newbie

Re: Nested If statement

You said "delete that row on the table". Which table? 

Can u provide me with the form please?

0 Kudos
Reply
mcswegin
Nintex Newbie

Re: Nested If statement

It is just a two column table. 'Divisions' on the left, 'States' for those divisions on the right. 

13 divisions total.

0 Kudos
Reply
avinashpatil
Nintex Newbie

Re: Nested If statement

Can you add a snapshot of the form? Michael McSwegin

Reply
pwarrak
Nintex Newbie

Re: Nested If statement

As per Avinash Patil‌ comment, please add  screenshot of the form.

0 Kudos
Reply
mcswegin
Nintex Newbie

Re: Nested If statement

0 Kudos
Reply