IF multiple factors are true THEN fill with specific cell label

[avavalley]

Hi all,

IF [Unit]="9733" AND [Code]="V888" AND [Link]="9733V888" THEN [Location]="LA" AND  [Classification]="Affiliate"

Trying to figure out a way to create an IF THEN statement correctly in which IF (multiple factors are true) THEN (fill the corresponding cells in that row for Location and Classification with their correct labels).  If there is a formula to do this that would be very helpful.

Thanks

[PhilipMannering · Accepted solution]

You need two formulae to update Location and Classification separately.

IF [Unit]="9733" AND [Code]="V888" AND [Link]="9733V888" THEN [Location]="LA" ELSE Null() ENDIF

and

IF [Unit]="9733" AND [Code]="V888" AND [Link]="9733V888" THEN [Classification]="Affiliate" ELSE Null() ENDIF

Replace the Null() with [Location] or [Classification] resepectively if you're updating fields

[avavalley]

Thank you, this helps! I am getting an error message saying: The field "" is not contained in the record. (Expression #1)

[danilang · Accepted solution]

Hi @avavalley 

In one of the formula's you forgot to specify the column to modify

Dan

[avavalley]

Ok thanks, I did that and it is now putting it in the correct cell but is entering "-1" in the cell instead of "LA".  Sorry for all the questions I appreciate your help.

[danilang · Accepted solution]

Hi @avavalley 

The next problems are caused by your Then actions 

THEN [Classification]="Affiliate"

The Output column that you fixed in the previous post is the target column for the action.  The proper syntax for the formula that applies the Classification column should be  

THEN "Affiliate"

Make the corresponding change in the other formula as well.

The first syntax 

THEN [Classification]="Affiliate"

actually compares the value in the Classification column for the current row with the string "Affiliate" and writes a -1 if this is true and 0 if it's false.

Dan

[avavalley]

Worked perfectly thank you!