General Cast - Can't Get Formula To Work

Platform discussions
1

Hi,

I am trying to update a email colum based off a selection of a status.

So if status changed to “Test” email colum should update to “test@test.com”

Here is my current forumula:

IF({item’s AM Support} = “Test”, “test@test.com”, “DO-NOTHING”)

When I select Test from the AM Support status colum, nothing gets populated in the email field.

Any ideas?

Thank you in advance

2

Hi there!

Try replacing your regular quotes with straight quotes ("") (Shift+fn+")

It’s a little finicky with the regular quotes. But your formula looks correct!

3

Hi,

I do actually have straight quotes, not sure why it has appeared like that above.

Here is is again:

IF({item's AM SUPPORT} = "Test", "test@test.com", "DO-NOTHING")

It just won’t work :frowning: