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
Solved! Go to 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,
@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
Thanks for this
Terry