IF THEN ELSE - need 2 THEN's to occur

[tkozlyk]

Need 2 THEN's to occur if 2 conditions are met.

So, 

IF

[Task1] = "Parts Received" and [Task Status] = "OPEN"

THEN [row-1:Task User] & also set field [PartsNotReceived] = “TRUE”

ELSE [Task User]

ENDIF

The unbolded formula above works OK - Now I need to also set a flag = TRUE (bolded above)

Thx

[Thableaus · Accepted solution]

Hi @tkozlyk 

You need to break in a second Multi-Row formula to change PartsNotReceived field.

The Multi-Row formula only updates a single field. Not possible to update two at a time.

Cheers,

[kelsey_kincaid · Accepted solution]

@tkozlyk My recommendation would be to split this out into 2 separate multi-row formula tools.

Formula 1:

IF

[Task1] = "Parts Received" and [Task Status] = "OPEN"

THEN [row-1:Task User]

ELSE [Task User]

ENDIF

Formula 2:

IF

[Task1] = "Parts Received" and [Task Status] = "OPEN"

THEN [PartsNotReceived] = “TRUE”

ELSE [Task User]

ENDIF

[tkozlyk]

Thanks for this

Terry