Workflow - Expression

AppSheet AppSheet Q&A
1

OK, Im trying to create a condition for a workflow, i want the condition to be something like this :

Send a notification to Alison’s cell if =

Columns [Team member 1][Team member 2][Team member 3][ASSIGNED TO] = “Alison”

Im obviously not writing it correctly. Can anyone help?

or do i have to create 4 different workflows for each scenario?

Thanks in advance.

2

Victoria_Winder1:

Columns [Team member 1][Team member 2][Team member 3][ASSIGNED TO] = “Alison”

What does this mean? Could you explain in plain language?

3

so when a form is submitted i want a work flow to send a notification to a person
if column

[Team member 1] or
[Team member 2] or
[Team member 3] or
[ASSIGNED TO]

is equal to their name

1 Like
4

I have a project management app, i can allocate tasks, i have the question, “is this task assigned to a team?”, if it is, the end user inputs the team members, i then want the team members to get a notification via a workflow.

5

Try:

IN(
  “Alison”,
  LIST(
    [Team member 1],
    [Team member 2],
    [Team member 3],
    [ASSIGNED TO]
  )
)

See also:

1 Like
6

Victoria_Winder1:

so when a form is submitted i want a work flow to send a notification to a person> if column> > [Team member 1] or> [Team member 2] or> [Team member 3] or> [ASSIGNED TO]> > is equal to their name

so when a form is submitted i want a work flow to send a notification to a person
if column

[Team member 1] or
[Team member 2] or
[Team member 3] or
[ASSIGNED TO]

is equal to their name

Thanks !