Triggering things

Ask for Help
1

Hi Again!

I’m trying to use “trigger formula” but I’m doing something wrong…

I want to fill column B with a value that depends on what column A have. Like this:

Trigger formula on column B

if $A == 'BRD':
    value='bread'
elif $A == 'BTT':
    value='butter'
else:
    value='anything else'
Return value

Please, what I’m doing wrong?

2

Your ‘return’ should not be capitalised. Other than that, it looks fine:

if $A == 'BRD':
    value='bread'
elif $A == 'BTT':
    value='butter'
else:
    value='anything else'
return value
2 Likes
3

Aff… is always something like this… hehheheh

At least, the principle was right!

Thanks!

1 Like