IF THEN ELSE - need 2 THEN's to occur

Question

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 Answer

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 Answer

@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